Get count after filter

[Vaishnavi457]

Hi all,

I have a gallery with column name status and when I apply filter based on status(Approved/pending/rejected) at same same time . I need a count of status from gallery . How I get count of like how many pending/approved/rejected .

Thanks,

Vaishnavi

[zmansuri]

I am guessing you are showing this count of the gallery in a label?

Then lebel's text property:

CountIf(Gallery1.AllItems,Status="Approved")

The above code will give you number of approved status in the gallery.

[Chitrakant27 · Accepted solution]

Hi @Vaishnavi457 ,

You can take a simple 3 - label and apply code on text property

"Pending-"&CountRows(Filter(Galleryname.AllItems,Status.Value="Pending"))

 "Approved-"&CountRows(Filter(Galleryname.AllItems,Status.Value="approved"))

"Rejected-"&CountRows(Filter(Galleryname.AllItems,Status.Value="rejected"))

Thanks,

Chitrakant27