![]() Each of those slicers is reading off of a simple table that just has values that range from 0-100. Just for a bit of context that would make the code make a bit of sense without seeing the report, on each page of this report I've added in drop down slicers that the end user can use as selectors to adjust their goals for different tiers. If(SurveylessthanAnswer,SurveyScore,AnswerGoal))))))Ī slightly simpler example is below here. If(AnswerlessthanTitle & AnswerlessthanSurvey,AnswerGoal,CurrentTitle)), If(SurveylessthanTitle & SurveylessthanAnswer,SurveyScore, If(isblank(AnswerGoal) || isblank(SurveyScore), CurrentTitle, EM Use: Low Tech 116Physical Notebook: address book, binder, composition book, date book, diary, filofax, journal, lab book, memo book, organizer. If(values(TMD)="CCS" || values(TMD)="Escalation CCS", If(SurveylessthanSC,SurveyScore,statusgoal))), If(SClessthanTitle & SClessthanSurvey,statusgoal,CurrentTitle)), Clicking the column header does the same sorting for viewing purposes only. If(SurveylessthanTitle & SurveylessthanSC,SurveyScore, If(isblank(statusgoal) || isblank(SurveyScore), CurrentTitle, If(SurveylessthanTT,SurveyScore,TTGoal))), If(TTlessthanTitle & TTlessthanSurvey,TTGoal,CurrentTitle)), ![]() If(SurveylessthanTitle & SurveylessthanTT,SurveyScore, If(isblank(TTGoal) || isblank(SurveyScore), CurrentTitle, If(values(TMD)="Mainstream PS" || values(TMD)="NY PS", After I started using variables, the performance of the report loading visuals was almost instantaneous rather than taking upwards of 10-15 seconds just to load a matrix/table visualization, if it loaded those visuals at all. It's essentially just a series of nested if statements. Sorry if it seems a bit like a jumbled mess. I used to have everything here that you see as variables written into what is now the return statement. This is probably one of the more complicated measures I had in my report. There might be better ways to do most of what I did but it works and loads quickly so I got what I needed. None of my DAX is too crazy and is probably pretty basic to someone who is an expert.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |