HCP All Base Dashboard display KPI's on the central part of the report and on the all vizualizations.
HCP All Base
Displays the total number of healthcare professionals included in the complete CRM database.
Business Value
Represents the total HCP universe available for engagement and coverage analysis.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_hcp_all_base_csv[doc_crm_id])
)Calculation Logic
Calculates the total number of unique healthcare professionals stored in the complete HCP database.
Business Rules
- All active filters affect calculations.
- Includes all HCPs available in the selected reporting scope.
HCP All Base Coverage
Displays the number of healthcare professionals from the complete HCP database who received at least one interaction during the reporting period.
Business Value
Measures actual engagement coverage across the full HCP universe.
DAX Formula
VAR FilteredTasks =
FILTER(
crm_hcp_all_base_tasklastmonth_csv,
NOT ISBLANK(crm_hcp_all_base_tasklastmonth_csv[task_last_month])
)
RETURN
CALCULATE(
DISTINCTCOUNT(crm_hcp_all_base_csv[doc_crm_id]),
FilteredTasks
)Calculation Logic
Calculates the number of unique healthcare professionals who have at least one recorded interaction during the last month.
A healthcare professional is considered covered when the task_last_month field contains a value.
Business Rules
- Multiple interactions with the same healthcare professional are counted once.
- Coverage is determined using the latest activity data.
- All active filters affect calculations.
HCP All Base Uncovered
Displays the number of healthcare professionals who have not been covered by field activities.
Business Value
Helps identify engagement gaps and uncovered customer segments.
DAX Formula
[HCP All Base] - [HCP All Base Cov]Calculation Logic
Calculates the difference between the total HCP database and covered healthcare professionals.
Business Rules
- Represents HCPs with no qualifying activity during the reporting period.
- Recalculated dynamically according to active filters.
HCP All Base Coverage %
Displays the percentage of covered healthcare professionals relative to the complete HCP database.
Business Value
Measures overall customer engagement effectiveness.
DAX Formula
DIVIDE(
[HCP All Base Cov],
[HCP All Base],
0
)Calculation Logic
Calculates the ratio of covered healthcare professionals to the total HCP database.
Business Rules
- Returns 0 when the denominator is zero.
- Recalculated dynamically according to active filters.
- Used as the primary indicator of overall HCP coverage.