Count number of checked items within a gallery

[TOJMK]

Hello Everyone,

I'm trying to count the number of checked checkboxes by a category ( group by item ) and have the same result in a new column of the same gallery. 

example : 

in the red box is what I want to achieve 

I tried with the formula below but Im getting a circular reference error.

Is there any was to achieve this please ? 

Thanks in advance 

[Maceo]

Hi TOJMK,

In my opinion, if you want to use a formula with gallery. You can't directly use this in the gallery inside. Otherwise it will cause some direction mistake.

Thanks,

Maceo

[Maceo]

Solution in my thought:

1.Change the Oncheck&OnUncheck function for Checkbox, use a variable to store the number of checked.

Set(
    var1,CountRows(
    Filter(
        Gallery1.AllItems,
        Checkbox1.Value
    )
))

 2.Use the variable for the text in Label

Hope this can help you.

Thanks,

Maceo

[TOJMK]

Hi Maceo, 

thank you for your reply, with the proposed solution I can not get the number of checked without group by. 

what I want to achieve is a count group by item  ( like the screenshot ITEM1 = 2 , ITEM2=0) 

[Maceo]

Oh, probably I got what you mean, you want to show the total amount that checked in Item1 etc.

Is I correct? It will be a great challenge.

Thanks,

Maceo

[TOJMK]

yes, any idea or solution for this topic?