Forum Discussion
Solved
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:
FreemanZ
Super User
Super Userhi 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: