How to Sum measure with MAX?

[lucie_rabochova]

Hi all,

I have very simple measure with MAX value. Issue is that Total showing MAX value too, but I need to show SUM of all MAX values in the table. 

Basically

Total should summary of all values: 60,000 for upper_value and 51,000 for lower_value. 

see printscreen:

This is desktop file:

https://drive.google.com/file/d/1_R84-65eDKQunYTwyr888yID97tdhGUR/view?usp=drive_link

Thank you for your help on this!

[lucie_raboch]

Hi,

thank you for your answer.

This is new link to the file: https://drive.google.com/file/d/1_R84-65eDKQunYTwyr888yID97tdhGUR/view?usp=drive_link

The size of the file has been reduced.

The file contains data from BQ public dataset. There are two metrics - impressions - lower and impressions - upper.

I have various charts and tables in the original dashboard,  I need to create a measure showing total like summary and not like MAX, but the rows must remail like MAX. 

This is powerbi file showing total 5000 and 4000 impressions, (individual rows are showing correct values)

and this is excel version this is what I need to see in all visualisation across dashboard.

Do you think this is possible?

[lbendlin · Accepted solution]

upper_value = 
var a = ADDCOLUMNS(summarizecolumns(ads[creative_id]),"m",CALCULATE(MAX(statistics[times_shown_upper_bound_region])))
return sumx(a,[m])

[lucie_rabochova]

This is absolute amazing solution, thank you so much! It works!

[lbendlin]

Your sample file is way too big. Please provide sample data that fully covers your issue, but not more.
Please show the expected outcome based on the sample data you provided.

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.