Calls Made - to Include additional criteria

[Anonymous]

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_name	Activity_Type_1	HCP Type	Date
c0189969	blank_call_type	GP	16/12/2022
c0189970	blank_call_type	Nurse	18/02/2022
c0189971	blank_call_type	GP	23/02/2022
c0189972	blank_call_type	Doctor	03/05/2022
c0189973	blank_call_type	Helper	06/03/2022
c0189974	blank_call_type	Porter	19/03/2022
c0189975	customer_facing	Doctor	27/02/2022
c0189976	blank_call_type	Helper	19/02/2022
c0189977	blank_call_type	Porter	17/02/2022

[v-zhangti · Accepted solution]

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.