Solved: Re: Filtering Grouping Questions

PeterWu · ‎07-08-2021

Hi

I've a data set like below , is there any possibility that I select "AAA" and the visual will show AAA & BBB, because they are same grouping?

Jihwan_Kim · ‎07-08-2021

Show measure =
VAR _newtable =
FILTER ( Data, Data[Grouping] IN VALUES ( Slicer[Grouping] ) )
RETURN
COUNTROWS ( _newtable )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

PeterWu · ‎07-08-2021

Great!! let me tried if this solutions works

Jihwan_Kim · ‎07-08-2021

Show measure =
VAR _newtable =
FILTER ( Data, Data[Grouping] IN VALUES ( Slicer[Grouping] ) )
RETURN
COUNTROWS ( _newtable )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Filtering Grouping Questions