cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Calculate percent of a number

This is a very straight forward problem but I haven't been able to find the correct method.  I just want to calculate the percentage of a number.  I'll use that number in another calculation.  I've tried a variety of things that I've modified from other people's work but no luck.  Here's one, as an example:  Cost X = SUM(Table1[Actual Cost])*.10

 

I get results that aren't 10% of the value and I haven't been able to determine the logic in the results yet.  Any input would be appreciated.

1 ACCEPTED SOLUTION

@Anonymous

 

Column=Table1[Actual Cost]*.10

 


Regards
Zubair

Please try my custom visuals

View solution in original post

7 REPLIES 7
MathFour
Frequent Visitor

I'm not sure, but I'd first check your order of operations. Perhaps Microsoft does multiplication before SUM. Try an extra set of parenthesis before the *.10.

Okay, that was dumb - due to the distributive property, that wouldn't matter. 

 

But maybe there's a different way of logic.

 

Regardless, parenthesis are cheap. Give those a try. Maybe it'll be just the right kick in the machine to make it work.

Anonymous
Not applicable

Thanks for the try but no effect. 

 

As an example of the results, 203,000 became 722,692 and the next number (which was completely different) also resulted in 722,692.  Some results repeat for no reason and others don't. 

 

I plugged all of the numbers into a tool to see if the program could determine the pattern but it couldn't find any either. 

 

Just for kicks, I also tried the following with the same results: SUM(Table1[Actual Cost]) * (10/100) .  

 

For what it's worth, I tried this as a Measure and as a Calculated Column but the same results.

 

 

Hi,

 

This formula should definitely be a measure.  Share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Unfortunately, I can't share the file.  I'm building this for a customer and it has their sensitive data in it. 

 

I did try a measure, like you suggested, but it didn't work.  I thought this would be a simple DAX statement but maybe there's more to it in PBI?

@Anonymous

 

Column=Table1[Actual Cost]*.10

 


Regards
Zubair

Please try my custom visuals

View solution in original post

Anonymous
Not applicable

Hi Zubair,

That worked perfect.  Thanks again for your help!  As I suspected, it was extremely simple but I couldn't find a single example of this anywhere. 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors