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.

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.