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 Count of Employees

 

So, If Year = 2019, Location = CA, and Gender = M comes to 5500 / Entire population in the Table = 10,000

 

Thanks

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 () )
)

3 Replies

  • 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

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    sabeensp 

     

    You may try ALL without arguments.

    Measure =
DIVIDE (
    COUNTROWS ( Employees ),
    CALCULATE ( COUNTROWS ( Employees ), ALL () )
)