Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've tried several answers to some of the same questions in here, but it still doesn't show the right percentage of used amount for each department in my matrix
I want to show "amount used" of a "budget" for each "department" in some defined "months". Can anyone help me to make the rigth measure/s?
It should be columbased, if that means anything.
An exampel:
Month Department Used Budget Percentage used
2 AMA 150 200 75%
I dont know, if I should make a new colum where i have divided "used amount" and "budget" og just make a new measure. I have tried both, but I get a "NaN", "Infinity" og a number that doesn't make sense.
Regards Jonas
Solved! Go to Solution.
Hi @Anonymous,
According to your description above, you should be able to use the formula below to create a measure to calculate the percentage in your scenario.
Percentage Measure = DIVIDE ( SUM ( 'Ark1 (2)'[Used] ); SUM ( 'Ark1 (2)'[Budget] ) )
Regards
You just need to check the data you are using to calculate the measure.
Only when denominator is zero , result will be infinity.Either the data needs data cleaning or data modelling.
If this doesn't work , feel free to share further details.
As you can see, I made this in the formula bar, where i get 100 % even though it shouldn't be. Dont mind the names "Total People Column". The names is from another sheet.
Hi @Anonymous,
According to your description above, you should be able to use the formula below to create a measure to calculate the percentage in your scenario.
Percentage Measure = DIVIDE ( SUM ( 'Ark1 (2)'[Used] ); SUM ( 'Ark1 (2)'[Budget] ) )
Regards
Thank you so much v-ljerr-msft, that works perfectly 🙂
But what should I type in either "New Colum" or "New Measure"?