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.
Hi,
I have a employee table which is associated with Program's table. These together will provide the information about the employees who participated or not participated on program sessions. I have built a measure for number of employees who participated on sessions which gets changed according to program name selection and I would like to build a measure to count the total number of employees on employee table which never changes according to program name.
To be precise I have a slicer on top of program name and I have a card on top of number of total employees. When the user choses a specific program on the slicer, the count on card should not change whereas it will be static always. How can I achieve this ?
In microstrategy I can create a level metric at employeeid level, so the metric will always produce the same count regardless of program names.
Solved! Go to Solution.
The following CROSS FILTER function worked which isolates employee from program_participation.
Hi @Kaviprakash ,
What is the relationship between employee table and Program's table. How about setting the relationship to both to check again?
The following CROSS FILTER function worked which isolates employee from program_participation.
@Kaviprakash - You can create a new measure, that will be used in the card. It will look something like the following. Note: This will always show the number of rows in the employee table - never affected by any slicers.
Number of Employees = COUNTROWS(ALL('Employee'))
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |