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.
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"?
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 |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |