DAX Min/Max and Strategic Values

[Anonymous]

Hi all. 
My calculations to get the strategic values work as a total (see 1st picture), but when I add the UPRN, I lose the values (2nd picture) How could I have these strategic values, but UPRN?  
Many thanks! 

Below are the measures I used.

Strategic Value SAP Rating =

divide(

sum(Costs[SAP Rating]) -[Min SAP Rating],

[Max SAP Rating] - [Min SAP Rating]

)

Strategic Value Planned maintenance PV 30 years =

divide(

sum(Costs[Planned maintenance PV 30 years]) -[Min Planned Maintenance PV 30 years],

[Max Planned Maintenance PV 30 years] - [Min Planned Maintenance PV 30 years]

)

Strategic Value Net Surplus =

divide(

sum(Costs[Net Surplus Generated from Sale]) -[Min Net Surplus Generated from Sale],

[Max Net Surplus Generated from Sale] - [Min Net Surplus Generated from Sale]

)

Strategic Value = Costs[Strategic Value SAP Rating]+Costs[Strategic Value Planned maintenance PV 30 years]+Costs[Strategic Value Net Surplus]/3

MIN measure is the same for the Planned Maintenance and Net. 

Min SAP Rating = CALCULATE( MIN(Costs[SAP Rating]), FILTER(Costs, Costs[SAP Rating] > 0 || Costs[SAP Rating] <> BLANK()))

[v-jingzhang]

Hi @Anonymous 

Is UPRN a column field? If so, when you put a column into a table visual, it will apply filter context on the other measure fields in the table visual. In this context, the measures all return blank values so you just see blank in the second picture. 

What is in UPRN? Does it have multiple values and you want to have different results of those measures for them separately?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.