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(Dist...
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.

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.