Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calls Made - to Include additional criteria

Hi Experts

 

The following measure gives me the unique #call made and returns back the correct results. What i want to do is take into consideration the HCP Type Column...

Measure = Calculate(Distinctcount(table[crm_call_name]),Filter(Values(Table),not(table[activity_type_1] IN {"customer_facing","blank_call_type"})))

 

Sample Data

crm_call_nameActivity_Type_1HCP TypeDate
c0189969blank_call_typeGP16/12/2022
c0189970blank_call_typeNurse18/02/2022
c0189971blank_call_typeGP23/02/2022
c0189972blank_call_typeDoctor03/05/2022
c0189973blank_call_typeHelper06/03/2022
c0189974blank_call_typePorter19/03/2022
c0189975customer_facingDoctor27/02/2022
c0189976blank_call_typeHelper19/02/2022
c0189977blank_call_typePorter17/02/2022
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    Measure:

    Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[crm_call_name] ),
    FILTER (
        VALUES ( 'Table' ),
        NOT ( 'Table'[Activity_Type_1] IN { "customer_facing", "blank_call_type" } )
            && [HCP Type] = SELECTEDVALUE ( 'Table'[HCP Type] )
    )
)

    If this does not solve your problem, please picture the output you expect.

     

    Best Regards,

    Community Support Team _Charlotte

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

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    Measure:

    Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[crm_call_name] ),
    FILTER (
        VALUES ( 'Table' ),
        NOT ( 'Table'[Activity_Type_1] IN { "customer_facing", "blank_call_type" } )
            && [HCP Type] = SELECTEDVALUE ( 'Table'[HCP Type] )
    )
)

    If this does not solve your problem, please picture the output you expect.

     

    Best Regards,

    Community Support Team _Charlotte

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