Forum Discussion

millercj's avatar
millercj
Regular Visitor
1 year ago
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...
Need Help
  • sanalytics's avatar
    sanalytics
    1 year ago

    millercj 

    you can try below measure

    Count_Customers_ActivePolicy1 =
CALCULATE(
    DISTINCTCOUNT(Entities[CustomerID]),
    FILTER(
        Entities,
        [ActivePolicyCount] = 1
    )
)

     

    Regards

    sanalytics

ajohnso2's avatar
ajohnso2
Icon for Solution Supplier rankSolution Supplier
1 year ago

If your Policies[Active] column is not a boolean type you should change to Policies[Active] = 1

Either way the dax should work now, for multiple filters use the required operator && (and) || (or) etc not ,

 

ActivePolicyCount = 
CALCULATE(
    COUNTA(Policies[UID]),
    Policies[Active] = TRUE() && PolicyLines[DisplayName]<>"Annuity"
)

 

 

If this helps can i get some free insurance? 😄