HCO Base
Displays the total number of healthcare organizations included in the selected reporting scope.
Business Value
Represents the planned HCO base assigned for coverage.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_owner_v2_csv[key_cleint_id]),
crm_owner_v2_csv[flag_name] = "company"
)Calculation Logic
Calculates the unique number of clients of type company in the responsible employee base.
Covered
Displays the number of healthcare organizations that received at least one completed interaction during the selected period.
Business Value
Shows how many organizations were actually covered by field activity.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_cleint_id]),
crm_task_fact_v2_csv[key_flag] = "company"
&& crm_task_fact_v2_csv[key_task_isfinish] = 1
)Calculation Logic
Calculates the unique number of healthcare organizations with at least one completed visit.
Covered Owner
Displays the number of healthcare organizations covered by their assigned representative.
Business Value
Used to calculate coverage of the responsible employee’s own HCO base.
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] = "company"
)Calculation Logic
Calculates unique healthcare organizations visited by their responsible employee.
Covered %
Displays the percentage of covered healthcare organizations within the assigned HCO base.
Business Value
Measures HCO coverage effectiveness.
DAX Formula
DIVIDE([HCO Covered owner], [HCO Base], 0)Calculation Logic
Calculates the ratio of covered own HCOs to the total HCO base.
Returns 0 when the denominator is zero.
Uncovered
Displays the number of healthcare organizations that did not receive any completed interaction.
Business Value
Helps identify organizations that still require field activity.
DAX Formula
[HCO Base] - [HCO Covered owner]
Calculation Logic
Calculates the difference between the assigned HCO base and HCOs covered by their responsible employee.
HCO Calls
Displays the total number of completed calls to healthcare organizations.
Business Value
Measures field activity volume related to HCOs.
DAX Formula
CALCULATE(
DISTINCTCOUNT(crm_task_fact_v2_csv[key_task_id]),
crm_task_fact_v2_csv[key_flag] = "company"
&& crm_task_fact_v2_csv[key_task_isfinish] = 1
)Calculation Logic
Calculates the unique number of completed visits to clients of type company.
Frequency
Displays the average number of calls per covered healthcare organization.
Business Value
Helps evaluate engagement intensity with covered organizations.
DAX Formula
DIVIDE([HCO Calls], [HCO Covered], 0)Calculation Logic
Calculates the ratio of completed HCO calls to covered HCOs.
Returns 0 when the denominator is zero.