Forum Discussion
Praveen0303
1 year agoNew Member
Dax
Based on the quater selection dynamically comments also need to change,if select all quater it's shows Quater 3 comments how to write Dax condition
hi Praveen0303 ,
try to plot a visual with a measure like this:
Measure = IF( COUNTROWS(VALUES(data[Qtr]))=COUNTROWS(ALL(data[Qtr])), MAXX(FILTER(data, data[Qtr]="Q3"), data[Comments]), MAX(data[Comments]) )it worked like:
1 Reply
- FreemanZ
Super User
hi Praveen0303 ,
try to plot a visual with a measure like this:
Measure = IF( COUNTROWS(VALUES(data[Qtr]))=COUNTROWS(ALL(data[Qtr])), MAXX(FILTER(data, data[Qtr]="Q3"), data[Comments]), MAX(data[Comments]) )it worked like: