Work out calls over a week

Hi Anonymous 

I am a little bit confused to be honest since it is not described why your current measure does not give you the expected result.

Based on your information you can also try the following versions:

SumValues = 
CALCULATE(
   DISTINCTCOUNT('act_rates_activity_volume_and_cf_days'[crm_call_name]),
   FILTER(
      act_rates_activity_volume_and_cf_days,
      act_rates_activity_volume_and_cf_days[activity_type_1] = "f2f"
   )
)

or 

SumValues = 
CALCULATE(
   DISTINCTCOUNT('act_rates_activity_volume_and_cf_days'[crm_call_name]),
      (act_rates_activity_volume_and_cf_days[activity_type_1] = "f2f"
)

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn