Forum Discussion

sjacob's avatar
sjacob
Frequent Visitor
2 years ago
Solved

DAX Calculation for Unique Sum

Hello, I would like to get some help and support with the following DAX I've created:   Direct Group Time = SUMX(     FILTER('crdb contact', NOT(ISBLANK('crdb contact'[ContactGroupID])) && 'crdb...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    sjacob Try this:

     

    Measure 3 = 
SUMX ( 
    SUMMARIZE ( 
        FILTER ( MyTable2, MyTable2[ContactGroupID] <> 0 ),
        MyTable2[ContactGroupID], 
        MyTable2[Time1], 
        MyTable2[Time2] 
    ), 
    [Time1] + [Time2] 
)
parry2k's avatar
parry2k
Super User
2 years ago

sjacob Try this:

 

Measure 3 = 
SUMX ( 
    SUMMARIZE ( 
        FILTER ( MyTable2, MyTable2[ContactGroupID] <> 0 ),
        MyTable2[ContactGroupID], 
        MyTable2[Time1], 
        MyTable2[Time2] 
    ), 
    [Time1] + [Time2] 
)
  • sjacob's avatar
    sjacob
    Frequent Visitor
    2 years ago

    Hello parry2k thank you very much for this update. This works perfectly! Appreciate your support with this.