cancel
Showing results for
Did you mean:
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
Community Champion

@Anonymous

Column=Table1[Actual Cost]*.10

Regards
Zubair

7 REPLIES 7
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.

Frequent Visitor

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.

Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
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?

Community Champion

@Anonymous

Column=Table1[Actual Cost]*.10

Regards
Zubair

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.

Announcements

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.