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

Percentages with Measures

Hello,

 

I have a dataset that I exported from Excel and I have trying to create some measures. I am trying to create measures to give me the percents so I would have percents for "No Overdue," "<8 Overdue," and "8 or > Overdue." I am having trouble trying to create a measure that would allow me to do this. The numerator for the measure would be each of the columns that I listed, and the denominator would be total employees.

 

power bi 1.JPG

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Percentages with Measures

Hi @BrandonP2121 

 

You can use SUM( table[Column Name] ) instead of a measure, it will sum each month individually as long as the month column is placed in the visual.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Percentages with Measures

Hi @BrandonP2121 

 

You can create Measure for % of Overdue like below, and use the same logic for the rest.

 % of Overdue = DIVIDE( [Totl Employees],  [No Overdue] )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

BrandonP2121 Helper II
Helper II

Re: Percentages with Measures

Does it matter if I want to sort this by month, or can I just add the month filter onto this? It also isn't letting me pull the columns into the Measure? Does it only allow you put put your own measures in, or can you put the columns into a new measure?

Super User IV
Super User IV

Re: Percentages with Measures

Hi @BrandonP2121 

 

You can use SUM( table[Column Name] ) instead of a measure, it will sum each month individually as long as the month column is placed in the visual.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

View solution in original post

BrandonP2121 Helper II
Helper II

Re: Percentages with Measures

Okay, I did that and I got the numbers for each month to display which brings me one step closer. The last step I am trying to do is divide by the total number of employees and display that number as a percent. I tried adding that to what I just did with the Sum(table[column]) but it didn't seem to work.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors