CountRows for Two Different Values

(0) Share

Report

Posted on by zapperrr

Hi, I'd like to count rows with two specific keywords but I can't seem to figure it out:

"Total # of Phones: " & CountRows(
 Filter(
 'IT Equipment List',
 'Make' = "Apple",
 'Make' = "Samsung"
 )
)

Is there a specific way that this needs to be done? It's simply a label outputting the number of rows under the Make column that has Apple AND Samsung

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @zapperrr, try this:

"Total # of Phones: " & CountRows(
 Filter(
 'IT Equipment List',
 'Make' = "Apple" ||
 'Make' = "Samsung"
 )
)

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com