Calculate the cost while ignoring duplicates

[WorkHard]

I'm sure this is easy but the logic escapes me.

In DAX, How would I ignore the duplicate while calculating the Cost?

ID	Cost	Desired Result
1	10	10
1	10
2	50	50
2	50

[AlB · Accepted solution]

Hi @WorkHard 

It would be easier to remove the duplicates in Poer Query. If you want the total cost without the duplicates, create a measure and place it in a card visual:

Measure =
SUMX ( DISTINCT ( Table1[ID] ), CALCULATE ( MAX ( Table1[Cost] ) ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers