Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total and % of different fields

facultyschoolsubstantive_fteStaff Category Grouping
ArtsSchool 10.56Academic
ArtsSchool 21Technical
ArtsSchool 30.89Academic
ArtsSchool 40.58Technical
ArtsSchool 1 1Academic
ArtsSchool 20.66Academic
ArtsSchool 40.7Academic
ArtsSchool 20.8Clerical

 

Above is an example of my table. What I'm looking to achieve it to show the sums of FTE for each of the staff category groupings by School. And then to show for example, the % of FTE for technical staff (by FTE) compared to all staff. So I'd like to be able to display these measures either in a table or a scorecard, but failing miserably with the DAX I've been trying. Can anyone help with some suggestions please?

 

Thanks.

 

 

DAX

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Let me know if this is what you require

     

     

    Pbix attached

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

     

    Thanks for your suggestion and help. That does help to an extent. Using your example I can now see the % of each staff category by School...

     

    ...but what I'd like to be able to do it calculate for example, the % of all staff categories by FTE against all staff FTE. So if 20 clerical staff and 100 total staff, be able to see that in a scorecard or table. The table should be flexible enough to display a number of measures also if that's possible?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

       

      Can you pls share me sample data in a table and the expected output ?

       

      Regards,

      Harsh Nathani