HCO All Base
Displays the total number of healthcare organizations in the complete HCO database.
Business Value
Provides a full HCO universe for extended coverage analysis.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_hco_all_base_csv[Organization id])
)Calculation Logic
Calculates the unique number of organizations in the complete HCO base, regardless of employee responsibility assignment.
HCO All Base Coverage
Displays the number of healthcare organizations from the complete HCO database that had at least one visit in the last month.
Business Value
Shows recent coverage of the full HCO database.
DAX Formula
VAR FilteredTasks =
FILTER(
crm_hco_all_base_tasklastmonth_csv,
NOT ISBLANK(crm_hco_all_base_tasklastmonth_csv[task_last_month])
)
RETURN
CALCULATE(
DISTINCTCOUNT(crm_hco_all_base_csv[Organization id]),
FilteredTasks
)Calculation Logic
Calculates unique healthcare organizations from the full HCO database where task_last_month is not blank.
HCO All Base Uncovered
Displays the number of healthcare organizations from the complete HCO database that were not covered in the last month.
Business Value
Helps identify uncovered organizations in the full HCO universe.
DAX Formula
[HCO All Base] - [HCO All Base Cov]Calculation Logic
Calculates the difference between the complete HCO base and covered HCOs from the complete base.
HCO All Base Coverage %
Displays the percentage of covered organizations within the complete HCO database.
Business Value
Measures overall HCO engagement across the full database.
DAX Formula
DIVIDE([HCO All Base Cov], [HCO All Base], 0)Calculation Logic
Calculates the ratio of covered organizations to the full HCO base.
Returns 0 when the denominator is zero.