cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Invesco
Helper IV
Helper IV

Work out calls over a week

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?

 

Invesco_0-1669660299072.png

 

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")))
1 ACCEPTED SOLUTION
Mikelytics
Resident Rockstar
Resident Rockstar

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

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

View solution in original post

4 REPLIES 4
Mikelytics
Resident Rockstar
Resident Rockstar

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

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
djurecicK2
Memorable Member
Memorable Member

Right, so what value does the measure return? 


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.
djurecicK2
Memorable Member
Memorable Member

@Invesco ,

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


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.