cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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

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

 

 

1 ACCEPTED SOLUTION

Hi @JonasB,

 

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. Smiley Happy

Percentage Measure = DIVIDE ( SUM ( 'Ark1 (2)'[Used] ); SUM ( 'Ark1 (2)'[Budget] ) )

 

Regards

View solution in original post

5 REPLIES 5
Solution Sage
Solution Sage

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.To Power BI Forum - SS. - 2.PNG

 

To Power BI Forum - SS.PNG

To Power BI Forum - SS. - 3.PNG

Hi @JonasB,

 

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. Smiley Happy

Percentage Measure = DIVIDE ( SUM ( 'Ark1 (2)'[Used] ); SUM ( 'Ark1 (2)'[Budget] ) )

 

Regards

View solution in original post

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

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors