DAX Measure not adding up

[Anonymous]

Hi Experts

Cannot see the error in my DAX Measure (the table below clearly shows the Sum of No and Yes as 130 but the total is 113) everything is in one master FACT table....meseaure below

Measure

ActivityCountTest_ = Calculate(distinctCOUNT('act_rates_activity_volume_and_cf_days'[crm_call_name]),

                        FILTER(VALUES(act_rates_activity_volume_and_cf_days),

                        not(act_rates_activity_volume_and_cf_days[activity_type_2] IN {"customer_facing_day","blank_call_type"})))

[Greg_Deckler]

@Anonymous This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Anonymous · Accepted solution]

worked it out

ActivityCount_ =

        sumx(SUMMARIZE(act_rates_activity_volume_and_cf_days,act_rates_activity_volume_and_cf_days[activity_type_1],act_rates_activity_volume_and_cf_days[MCCP Flag]),[ActivityCountTest_])

[Anonymous]

Hi Greg Tried it and no luck>>>>