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 All
I have a set of data for number of staff by grade, also another set of data for number of staff by grade which has achieved awards. I have two seperate column charts for these two sets of data. However, I would like to compare the number of staff with awards in grade vs the total number of staff in the grade.
Please could anyone suggest the way how to do it and what kind of grahics would be useful. Many thanks.
Solved! Go to Solution.
Hi @Apple08 ,
Suppose you have a relationship between two tables. Ensure that the direction of the relationship is both.
number of staff = COUNT('Table'[name])
number of staff with awards = COUNT('Table (2)'[name])
If there's no relationshi between tables. Modify the mesure as
number of staff with awards = CALCULATE(COUNT('Table (2)'[name]),FILTER('Table (2)',[level]=MAX('Table'[level])))
The following is the same as before.
number of staff = COUNT('Table'[name])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Apple08 ,
Suppose you have a relationship between two tables. Ensure that the direction of the relationship is both.
number of staff = COUNT('Table'[name])
number of staff with awards = COUNT('Table (2)'[name])
If there's no relationshi between tables. Modify the mesure as
number of staff with awards = CALCULATE(COUNT('Table (2)'[name]),FILTER('Table (2)',[level]=MAX('Table'[level])))
The following is the same as before.
number of staff = COUNT('Table'[name])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please if is it possible to show the percentage for each award level vs the staff level?
Excellent! Many thanks for your help Stephen 🙂
Create another column for the number of staff that have not gotten awards, and then use a stacked column chart to show both scenarios on top of each other.
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.