Forum Discussion
Solved
Measure on a measure
For reference, I am an insurance agent. Goal: I need to count the number of entities (customers) where ActivePolicyCount=1 I have a table named "Entities" (essentially customers). Within that...
you can try below measure
Count_Customers_ActivePolicy1 = CALCULATE( DISTINCTCOUNT(Entities[CustomerID]), FILTER( Entities, [ActivePolicyCount] = 1 ) )Regards
sanalytics
you can try below measure
Count_Customers_ActivePolicy1 =
CALCULATE(
DISTINCTCOUNT(Entities[CustomerID]),
FILTER(
Entities,
[ActivePolicyCount] = 1
)
)
Regards
sanalytics
That did it! Thank you!