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.
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 |
Arts | School 1 | 1 | Academic |
Arts | School 2 | 0.66 | Academic |
Arts | School 4 | 0.7 | Academic |
Arts | School 2 | 0.8 | Clerical |
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.
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?
Hi @Anonymous ,
Can you pls share me sample data in a table and the expected output ?
Regards,
Harsh Nathani
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |