Countrows in gallery

[gennarodp]

hello, i have a gallery that visualise data from sharepoint list.

i would like to count distinct title of the gallery.

i want to evitate delegation problem, counting directly in sharepoint list.

how can i do ?

thank you

[Drrickryp]

With(
    {gal: Gallery1.AllItems},
    CountRows(
        Distinct(
            gal,
            title
        )
    )
)

[eka24 · Accepted solution]

If countRows Datasource:

CountRows(Distinct(Datasource,Title))

If countRows Gallery:

Gallery Items:

Distinct(Datasource,Title)

Then count gallery items

CountRows(Gallery1.AllItems)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.