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

Jai-Rathinavel's avatar
Jai-Rathinavel
Icon for Super User rankSuper User
1 year ago

millercj If you just want to filter the table you can just Click the table visual on the right you can see Count of Activity measure just filter it to 1 and apply 

 

Did I answer your question? If yes, please mark my post as a solution.

 

Thanks,

Jai