Forum Discussion

Anonymous

Not applicable

4 years ago

Calculation not working in PBI Desktop.

Hello, I have a problem with a calculated column (please see below) that is giving the wrong result for the Net Strategic Value in my PBI table. The result should be around 40 and not 80. As an ...

Need Help

amitchandak

Super User

4 years ago

Anonymous , This need to be a measure like

Net Surplus Sale Strategic Value =
var Max_value = CALCULATE(MAX(Costs[Net Surplus Generated from Sale]), ALL())
var Min_Value = CALCULATE(MIN(Costs[Net Surplus Generated from Sale]), ALL())

return Divide(Sum(Costs[Net Surplus Generated from Sale])-Min_Value, (Max_value- Min_Value))*100

The first calculation you have given can work as new column

Anonymous

Not applicable

4 years ago

Thanks for your reply amitchandak
But I've tried it a measure and I get exactly the same result.

amitchandak
Super User
4 years ago
Anonymous ,

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Anonymous
  Not applicable
  4 years ago
  Unfortunately, I don't have permission to share pbix files here.
  - Anonymous
    Not applicable
    4 years ago
    Hi Anonymous,
    
    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
    
    How to Get Your Question Answered Quickly
    
    Notice: you can upload to the network drive and share links here or paste the dummy data on your report in table format.
    
    Regards,
    
    Xiaoxin Sheng