Graphics to compare data

[Apple08]

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.

[Anonymous · Accepted 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.

[Apple08]

Please if is it possible to show the percentage for each award level vs the staff level?

[Apple08]

Excellent!  Many thanks for your help Stephen 🙂

[lbendlin]

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.