cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## calculate value and drop duplicates in groups

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.

1 ACCEPTED SOLUTION
Super User

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] ) )
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

3 REPLIES 3
Super User

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] )
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Anonymous
Not applicable

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.

Super User

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] ) )
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.