Item Statement to filter by counting Falses = 0

(1) Share

Report

Posted on by CP-23071818-0

107

I have a screen that I am using act as a Status Report screen

I have a Vertical gallery displaying data with a progress bar control

Item Statement:

GroupBy(Filter(ECI_Dies_1,Business_unit=Dropdown3.SelectedText.Value),eci_id,product,Purpose,Priority,content,cavity,completed)
 
Since the data source (SP list) is Patched records where ID number is allowed to be duplicated and the uniqueness comes from a different column.
the completed column is a Yes\No checkbox in SP list. 
 
how can I ammend this statement to also exclude any of the groups of eci_id's where all the records 
Here is a sample of the gallery data. above the progress part represents the number of child records that have a matching eci_id
(the first number on the left side). in this case i would like AACT-0106 to not show in the gallery because 7 of 7 are complete
 
What i TRIED was adding a count to the criteria in the filter statement but it produced an error that showed no data.

Categories:

General Questions

All responses (2)

Answers (1)

CP-23071818-0 107 on at

Like (0)

Report

Item Statement to filter by counting Falses = 0

That worked! had to make a tweek to change a field since the data was imported to the SP list initially (out of my lack of understanding) i had to use Field_2 to read the completed column but it works thank you!
Verified answer

WarrenBelz 146,601 Most Valuable Professional on at

Like (0)

Report
Item Statement to filter by counting Falses = 0

Hi CP-23071818-0

Probably something like this
AddColumns( Filter( GroupBy( Filter( ECI_Dies_1, Business_unit = Dropdown3.SelectedText.Value ), eci_id, product, Purpose, Priority, content, cavity, Grouped ), CountRows( Filter( Grouped, complete ) ) <> CountRows(Grouped) ), Summary, CountRows( Filter( Grouped, complete ) ) & "/" & CountRows(Grouped) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee