cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
szub Frequent Visitor
Frequent Visitor

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 example I am trying to calculate the percentage of claims where a servicer arrived the same day.  This is a data point that most, but not all of my branches collect. I am dividing the count of claims where the servicer arrived the same day by the total claim count and I would like the total claim count to only include the claims with specifc branch names.  I created a formula to get claim counts by one branch, but cannot add more than one "branch" name in the formula without getting an error.  = CALCULATE('Table'[Claim Count],'Table'[Branch] = "Branch A")

 

Maybe there is a different way to achieve what I need?

 

Thank you for any assistance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kerrymr Regular Visitor
Regular Visitor

Re: How to get a count based on multiple criteria.

Try this:

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

 

Let me know if that works,

Kerry

View solution in original post

4 REPLIES 4
Highlighted
Kerrymr Regular Visitor
Regular Visitor

Re: How to get a count based on multiple criteria.

Try this:

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

 

Let me know if that works,

Kerry

View solution in original post

Community Support Team
Community Support Team

Re: How to get a count based on multiple criteria.

@szub ,

 

Could you please share some sample data and show the expected result?

 

Regards,

Jimmy Tao

 

 

szub Frequent Visitor
Frequent Visitor

Re: How to get a count based on multiple criteria.

@Kerrymr this worked.  Thank you!

Kerrymr Regular Visitor
Regular Visitor

Re: How to get a count based on multiple criteria.

Glad it helped.

Kerry

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,407)