Ignore Multiple Slicers in Measure

[sabeensp]

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

[v-chuncz-msft · Accepted solution]

@sabeensp 

You may try ALL without arguments.

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

[TomMartens]

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]

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