Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Count rows measures excluding few slicers selection

Hi Team,

I have a requirement where i have a view with all dimentions and transactions together.

Have 6 slicers in a page Slicer1, Slicer2, Slicer3.... Slicer6

Now I want 2 measures to be created

Measure1 = Count rows based on only slicer1 or slicer 2 selection and ignore if I select anyting in slicer 3, 4, 5 and 6.

Measure2 = Count rows based on only slicer 3, 4, 5 and/or 6 and ignore if I select anyting in slicer 1 and slicer 2

I want to show both measures side by side in a table visual.

All this data is in single view. I tried using ALL, ALLSELECTED, ALLEXCEPT. Nothing is working. Can someone please help me with the same?



Solution Sage
Solution Sage

if all your 6 slicers and sales tables are the same table, then you won't get anything.
you need to create separate dimensions for each slicer , and only then can you use REMOVEFILTERS, ALL

Yes @Ahmedx. You are 100% right.


But the problem is, if I seperate the dimensions (1 table for each dim slicer), slicers are not connected to each other.

I want slicers also to be interacted so that if I select a value in slicer 3, only the corresponding values should show in slicer 4.

Helper II
Helper II

@Ahmedx @Greg_Deckler @lbendlin @DOLEARY85  - Any help here is much appriciated. Thanks!



@lbendlin Thanks for your response. Like @Ahmedx mentioned, it is not working even if I use REMOVEFILTERS as everything is in same table/view.

You mentioned dimensions so I (wrongly) assumed you had a data model.  Please normalize your data as needed.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors