Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have a unique challenge (at least for me) that I can't figure out. It involves creating a calculated measure of 2 total values that are both percentages. I will try to explain:
The result looks like this:
This is exactly what we want and all is good. What I now want is to create a new Calculated Measure called "Utilization Rate to Target which would be Utilization Total / Target Utilization Total or as in the above example 62% / 88% = 70%. The added kicker is I need to use this in a completely different visual.
Is it possible to divide these 2 totals somehow?
TIA,
Kevin Coles
Please try this approach
Pct of Target Utilization =
AVERAGEX (
VALUES ( Table[Staff Name] ),
DIVIDE ( [Utilization], [Target Utilization] )
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat,
Thank you for the suggestion but I don't think this will work. I will give a bit more detail into the Utilization Calc.....each Employee Row is a summation of time card records. This is where the Direct Hours come from. So if you take the first row in my screen shot....the employee has many records in the given period that total 122 Direct Hours. The base hours is fixed for the period for all employees (7.5 hrs * 22 working days for the particular period I've shown). Direct (122) / Base (165) = 74% Utilization. But in order to get the proper average shown on the total line I actually calculate this column this way:
OK I was able to solve this by extrapolating my two calculations into one larger calculation. What I forgot was that the 2 visuals I have a filtered in a slightly different way. This means I can't actually include it in the second visual so instead I have made it its own card.
Does anyone know of a way to stack matrices such that they actually look like one?
Thanks,
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |