Forum Discussion

szub's avatar
szub
Helper III
6 years ago
Solved

How to get a count based on multiple criteria.

Hello, I am working on metrics and some of our branches do not collect all of the same data.  So, I am trying to have the metrics reflect  only those records where the information is populated.  For...
Need Help
  • Kerrymr's avatar
    Kerrymr
    6 years ago

    Try this:

    CALCULATE('Table'[Claim Count],'Table'[Branch] IN {"Branch A", "BranchB", "BranchC")

     

    Let me know if that works,

    Kerry

Kerrymr's avatar
Kerrymr
Helper I
6 years ago

Try this:

CALCULATE('Table'[Claim Count],'Table'[Branch] IN {"Branch A", "BranchB", "BranchC")

 

Let me know if that works,

Kerry

  • szub's avatar
    szub
    Helper III
    6 years ago

    Kerrymr this worked.  Thank you!

    • Kerrymr's avatar
      Kerrymr
      Helper I
      6 years ago

      Glad it helped.

      Kerry