Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
-----------------------------------------------------
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.
-----------------------------------------------------
Right, so what value does the measure return?
@Invesco ,
Is that measure giving you the expected result? Can you calculate manually to confirm?
The answer is 12 f2f calls based on the image over the week.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |