topic Re: Sum of MAX in DAX Commands and Tips

Sum of MAX

Jay20024 — Mon, 21 Oct 2024 16:08:11 GMT

Hi Folks,

Got a inventory where I got a calculated column. For each computer, gotta keep only one value (the max), to sum only the max

How can I get a measure that sum the max of each Computer Name in my pivot table ?

Thanks for your help folks !

Jihwan_Kim — Mon, 21 Oct 2024 17:25:19 GMT

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

expected result measure: = SUMX ( VALUES ( data[computer_name] ), CALCULATE ( MAX ( data[total_point] ) ) )

Jay20024 — Tue, 22 Oct 2024 07:40:28 GMT

Jihwan_Kim. Many thanks for your help, it works like a charm !

Jay20024 — Tue, 22 Oct 2024 07:41:15 GMT

Jihwan_Kim. Many thanks ! It works like a charm !