topic calculate value and drop duplicates in groups in DAX Commands and Tips

calculate value and drop duplicates in groups

Anonymous — Wed, 28 Sep 2022 07:55:55 GMT

Here is the data and I want to drop duplicate in "name" level by get the max value,

for example, after drop duplicates in name level, the sum value of type "high" is 2+5 rather than 2+2+5+4

do you have any ideas? Thank you.

Jihwan_Kim — Wed, 28 Sep 2022 12:23:51 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new table.

New table create = GROUPBY ( Data, Data[Type], Data[Category], "@MaxValue", MAXX ( CURRENTGROUP (), Data[Value] ) )

Anonymous — Wed, 28 Sep 2022 12:33:54 GMT

actually I am finding a way to create a measure that calculate the sum of the max value in category group,

the result is exactly like this,

is there a way to change the table into a measure? Thank you.

Jihwan_Kim — Wed, 28 Sep 2022 13:06:06 GMT

Hi,

thank you for your feedback, and please check the below picture and the attached pbix file whether it suits your requirement.

Expected outcome measure: = SUMX ( SUMMARIZE ( Data, Data[Type], Data[Category] ), CALCULATE ( MAX ( Data[Value] ) ) )