topic Re: How to Sum measure with MAX? in DAX Commands and Tips

How to Sum measure with MAX?

lucie_rabochova — Mon, 07 Apr 2025 13:43:29 GMT

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!

Re: How to Sum measure with MAX?

lbendlin — Mon, 07 Apr 2025 15:03:57 GMT

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.

Re: How to Sum measure with MAX?

lucie_raboch — Mon, 07 Apr 2025 17:39:49 GMT

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?

Re: How to Sum measure with MAX?

lbendlin — Mon, 07 Apr 2025 19:15:28 GMT

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

Re: How to Sum measure with MAX?

lucie_rabochova — Thu, 10 Apr 2025 12:19:44 GMT

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