Work out calls over a week

[Invesco]

Hi Experts

Need a measure to sum the day_value based on the Distinctcount of CRM_Call_Name and where the Activity is "f2f" not ure the below is correct?

this my meaure

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

                            FILTER(VALUES(act_rates_activity_volume_and_cf_days),

                            (act_rates_activity_volume_and_cf_days[activity_type_1] = "f2f")))

[Mikelytics · Accepted solution]

Hi @Invesco 

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

[djurecicK2]

Right, so what value does the measure return? 

[djurecicK2]

@Invesco ,

 Is that measure giving you the expected result? Can you calculate manually to confirm?

[Invesco]

The answer is 12 f2f calls based on the image over the week.