Answered

CountRows in Data Source if Status 'Active' or 'Other'

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Table1.

I have Radio2.

I have Label.

Label1 has the following formula. I am trying to count the number rows in the data source that have 'ACTIVE' if "ACTIVE" is chosen in Radio2, or the number of rows that have 'CML DIGITAL' if "CML DIGITAL" is chosen in Radio2.

I can only seem to get the entire count - 1008.

If(IsBlank(Radio2.Selected.Value),CountRows(Client_Collection),If(Radio2.Selected.Value = "ACTIVE" && ("ACTIVE" in Client_Collection.Subscriber_Status),CountRows(Client_Collection)))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

Assuming Subscriber_Status is a Text column, you need

CountRows( Filter( Lucerna_Client_Collection, Radio2.Selected.Value <> "ACTIVE" || Subscriber_Status = "ACTIVE" ) )

If it is a Choice column use Subscriber_Status.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thank you, Warren.

A tweak, if I may...

If the Radio is blank show all in gallery and give count of all in gallery,
If Radio is 'ACTIVE' show only 'ACTIVE' and give count of only 'ACTIVE',
If radio is 'CML DIGITAL' show only 'CML DIGITAL and give count of only 'CML DIGITAL'

I've got the filter 'show' in gallery part working, I just need the label to reflect each of the counts.
CountRows(
Filter(
Client_Collection,
Radio2.Selected.Value = "ACTIVE" &&
Subscriber_Status = "ACTIVE"
||
CountRows(
Filter(
Client_Collection,
Radio2.Selected.Value = "CML DIGITAL" &&
Subscriber_Status = "CML DIGITAL"
))))

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

Something like this should do it

CountRows( Filter( Client_Collection, Radio2.Selected.Value = Blank() || Subscriber_Status = Radio2.Selected.Value ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Got the following to work. Thanks!

CountRows(
Filter(
Client_Collection,
Radio2.Selected.Value = Blank() ||
Radio2.Selected.Value = Subscriber_Status
)
)

Was this reply helpful? Yes No