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
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    use REMOVEFILTERS

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

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

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

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