Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure not adding up

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"})))
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

3 Replies