Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
sraj
Responsive Resident
Responsive Resident

Percent of

Hi,

 

How can I show this percent calculation in a measure, any way I tried is not giving me the right value?

 

370,221,00 - 6.20% = 34,726,729.8.

 

Thanks!

7 REPLIES 7
sraj
Responsive Resident
Responsive Resident

@NickolajJessen 

 

Sorry that I was not very clear.  NO, the value is not hardcoded.

 
 [Total Remaining Value] - [%Value Loss] = TOTAL REMAIN Adjusted
370,221,00 - 6.20% = 34,726,729.8
 
What I am getting is 34,726,399 something.
 
Total Remaining value and % Value loss are calculated measures too.

Okay, so it's fairly close.

is it possible, that the 6.20 is a rounded up value? 
What happens if you pull the [%Value Loss] into a visual and add like 6 decimals?

is it possible, that the 6.20 is a roundedl

The %value loss is 6.200892%

Well that's why youre getting the that result then
370,221 - 6.200892% =  34,726,399

Is there anything I can do to show the correct value and not to it round up?

NickolajJessen
Solution Sage
Solution Sage

I'm not sure if this is what you are looking for

NickolajJessen_0-1672927277122.png

 

NickolajJessen
Solution Sage
Solution Sage

This is not a lot of information. Can you explain in a bit more detail what you are looking for exactly? 
Are the first the values hardcoded or measueres that can vary in value? Are you looking to show the entire calculation in a sort of concatenated string?

If you are not getting the right value, please do include what value you are getting and what method you used to get the incorrect reslult.
cheers

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors