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

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi millercj ,

Please try the bellow updated DAX:

CustomersWithOneActivePolicy = 
CALCULATE(
    COUNTROWS(Entities),
    FILTER(
        Entities,
        CALCULATE(
            COUNTA(Policies[UID], Policies[Active] = TRUE(), PolicyLines[DisplayName] <> "Annuity")
        ) = 1
    )
)