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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Calculated column with negative values.

Hi folks,
I'm having some issues in getting the correct result for the Net Strategic Value in my PBI table.
It's the calculated column below. The result should be as shown in the excel sheet. In PBI I'm getting a high value, what can I do to have a low value for negative numbers?

Net Surplus Sale Strategic Value =
var Max_value = MAX(Costs[Net Surplus Generated from Sale])
var Min_Value = MIN(Costs[Net Surplus Generated from Sale])
return ((Costs[Net Surplus Generated from Sale]-Min_Value) / (Max_value- Min_Value))*100

 

ROG_BI22_0-1646860337206.png

Thank you!

3 REPLIES 3
Anonymous
Not applicable

Hi  @Anonymous ,

You might consider using measure:

Net Surplus Sale Strategic Value =
var Max_value = MAXX(FILTER(ALL(Costs),'Costs'[UPRN]=MAX('Costs'[UPRN])),[Net Surplus Generated from Sale])
var Min_Value = MINX(FILTER(ALL(Costs),'Costs'[UPRN]=MAX('Costs'[UPRN])),[Net Surplus Generated from Sale])
return
((MAX( Costs[Net Surplus Generated from Sale])-Min_Value) / (Max_value- Min_Value))*100

If the result is not what you expected, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VahidDM
Super User
Super User

Hi @Anonymous 

 

Did you check the aggregation of this column in the visual?

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

 

Anonymous
Not applicable

Hi @VahidDM thanks for your reply. 

It's a SUM.

ROG_BI22_0-1646862272961.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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