Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Ignore Multiple Slicers in Measure

Hello, I have a Measure COUNT(Employees) I have mutiple slicers on the report Slicer1: Year Slicer2: Location Slicer3: Gender I need to divide Count of Employees selected by slicer values / All...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    sabeensp 

     

    You may try ALL without arguments.

    Measure =
DIVIDE (
    COUNTROWS ( Employees ),
    CALCULATE ( COUNTROWS ( Employees ), ALL () )
)
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

 

I'm wondering if you have just one table, or do you have a data model that build following the star schema approach.

Meaning you have different tables like Calendar and Employees?

In case you have just one large table you can try something like this:

Count all employees = 
CALCULATE(
    COUNT(Table1[Person])
    , ALL('Table1'[Gender] , 'Table1'[Location])
)

This will ignore the slicers from Gender and Location.

 

Regards,

Tom

  • sabeensp's avatar
    sabeensp
    Icon for Helper IV rankHelper IV
    7 years ago

    TomMartens  No I have over 10 slicers coming form 10 diff tables