topic Showing Common values in Developer

Showing Common values

Anonymous — Wed, 16 Jun 2021 11:31:29 GMT

I have a slicer which has 3 groups Group1 , Group2, Group3.
In table there are many users and few users belongs to 2 groups or 3 groups.
In the slicer selection if I select group 1 , it will show group 1 users if I select group 1 and 2 it will show all users exist in group 1 and 2

My requirement/doubt

1. when I choose group 1 and 2 from Slicer, my report should show only users belongs to or present in 1 and 2 both (like show only common users among groups)

Re: Showing Common values

Anonymous — Fri, 18 Jun 2021 06:20:37 GMT

Hi Anonymous ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

In addition, you can refer the content in the following blog to achieve it:

Apply AND Logic to Multiple Selection in DAX Slicer

Slicer with "AND"logic

Changing “OR” to “AND” Logic for Power BI Slicers

Best Regards