HCP Base Dashboard display KPI's on the central part of the report and on the all vizualizations.
HCP Base
Displays the number of healthcare professionals assigned to employee responsibility areas.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_owner_v2_csv[key_cleint_id]),
crm_owner_v2_csv[flag_name] = "contact"
)Calculation Logic
Calculates the unique number of healthcare professionals assigned to employees.
HCP Covered
Displays the number of healthcare professionals who received at least one completed visit.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_cleint_id]),
crm_task_fact_v2_csv[key_flag] = "contact"
&& crm_task_fact_v2_csv[key_task_isfinish] = 1
)Calculation Logic
Calculates unique healthcare professionals with at least one completed visit.
HCP Covered Owner
Displays the number of healthcare professionals covered by their assigned employee.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_cleint_id]),
crm_task_fact_v2_csv[key_owner_flag] = 1
&& crm_task_fact_v2_csv[key_task_isfinish] = 1
&& crm_task_fact_v2_csv[key_flag] = "contact"
)Calculation Logic
Calculates unique healthcare professionals covered by their responsible representative.
HCP Covered %
DAX Formula
DIVIDE(
[HCP Covered owner],
[HCP Base],
0
)Calculation Logic
Calculates coverage percentage for the assigned HCP base.
HCP Not Covered
DAX Formula
[HCP Base] - [HCP Covered owner]Calculation Logic
Calculates healthcare professionals assigned to employees but not yet visited.
HCP Calls
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_task_id]),
crm_task_fact_v2_csv[key_flag] = "contact"
&& crm_task_fact_v2_csv[key_task_isfinish] = 1
)Calculation Logic
Calculates the number of completed visits to healthcare professionals.
HCP Frequency
DAX Formula
DIVIDE(
[HCP Calls],
[HCP Covered],
0
)Calculation Logic
Calculates the average number of visits per covered healthcare professional.
Business Value
Helps evaluate engagement intensity and call frequency.