How to make a measure to show percentage used for each department

[Anonymous]

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

[rajulshah]

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.

[Anonymous]

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.

[v-ljerr-msft · Accepted 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

[Anonymous]

Thank you so much v-ljerr-msft, that works perfectly 🙂

[Anonymous]

But what should I type in either "New Colum" or "New Measure"?