Forum Discussion

akhilduvvuru's avatar
akhilduvvuru
Icon for Helper IV rankHelper IV
3 years ago

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 ...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

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

  • akhilduvvuru's avatar
    akhilduvvuru
    Icon for Helper IV rankHelper IV
    3 years ago

    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.