Dax

[Praveen0303]

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 

[FreemanZ · Accepted solution]

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: