Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You may try ALL without arguments.
Measure = DIVIDE ( COUNTROWS ( Employees ), CALCULATE ( COUNTROWS ( Employees ), ALL () ) )
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |