Forum Discussion

Meghbajaj's avatar
Meghbajaj
Frequent Visitor
3 years ago
Solved

Calculating Sum of Distinct Values

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...
Need Help
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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