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 Effective Date]),[Measure 1])

 

Please guide to get the desired result. Thanks

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.

     

2 Replies

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

  • 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.