Query Regarding DAX

Hi Anonymous ,

You could create a flag measure:

Flag = 
var _dis=CALCULATE(DISTINCTCOUNT('Table'[Event]),ALLEXCEPT('Table','Table'[User]))
var _countB=CALCULATE(COUNTROWS('Table'),FILTER('Table',[User]=MAX('Table'[User]) && [Event]="B"))
RETURN IF(_dis=1 && _countB>0,1,0)

And then apply it to visual-level filter pane, set as "=1":

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous ,

Did my method help you ? Please feel free to ask.

Best Regards,
Eyelyn Qin