Calculating Sum of Distinct Values

[Meghbajaj]

Hi Everyone,

I have the following table:

 Expected result: 7500

Result Obtained: 6500

Formulas Used:

Measure 1 = MAX(Table1[Bonus Amount])

Measure 2 = SUMX(DISTINCT(Table1[Bonus Effective Date]),[Measure 1])

Please guide to get the desired result. Thanks

[v-zhangti · Accepted solution]

Hi, @Meghbajaj 

You can try the following methods.

Measure 2 = SUMX(SUMMARIZE('Table','Table'[ID],'Table'[Bonus Effective Date]),[Measure 1])

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Meghbajaj , Try like

SUMX(Summarize(Table1,  Table1[Bonus Effective Date],Table1[Bonus Amount] ),[Bonus Amount])

or

SUMX(Summarize(Table1, Table1[ID], Table1[Bonus Effective Date],Table1[Bonus Amount] ),[Bonus Amount])