Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total and % of different fields

faculty school substantive_fte Staff Category Grouping Arts School 1 0.56 Academic Arts School 2 1 Technical Arts School 3 0.89 Academic Arts School 4 0.58 Technical ...
DAX
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