Sum of MAX

[Jay20024]

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 !

[Jay20024]

@Jihwan_Kim. Many thanks ! It works like a charm !

[Jihwan_Kim · Accepted solution]

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]

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