Answered

how to count a column based on another column

(0) Share

Report

Posted on by tbabe12

my table name is WorkOrder, and i would like to have a workorder number that shows all the vendor names for a particular job address and also count the vendor names for a particular job address.. eg for address 711., i want to be able to see all vendor names allocated to that address and also count the number of vendors in that address, instead of the repetition

Screen Shot 2021-05-31 at 2.36.57 PM.png

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tbabe12 ,
Where do you want to show these count numbers? In a gallery?
Do you want to show all vendor names when click a specified address in another gallery?
Please provide more information about your requirement.
Besides, I used to solved a thread that may be similar to yours, check if this is helpful to you:
Solved: Re: Show only the first record with a condition in... - Power Platform Community (microsoft.com)
Best regards,
Allen
tbabe12 52 on at

Like
a
(0)

Report
Copy link

Link copied!

exactly, i would like to be able to show counts number like the picture below, and all vendors names for a specific address in another gallery.. yes. Wos is the WorkOrder counts for a specific address. Thanks
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @tbabe12 ,
Sorry for my late reply.
I now understand your requirement and I think the post provided in my first reply did match your need. Have you checked my solution in that thread?
Anyway, I did a simple test on my side for your reference.
1. Here is my data structure, one idcliente with more than one address1:
2. Here is my first gallery. The Items property of this gallery is:
Distinct(Clientes,idcliente)
For you, this should be:
Distinct(WorkOrder,jobaddress)

Inside this gallery, I add a label control and set its Text property to:
CountIf(Clientes,idcliente=ThisItem.Result)
For you, it should be:
CountIf(WorkOrder,jobaddress=ThisItem.Result)
3. Here is my second gallery, the Items property of the second gallery is:
Filter(Clientes,idcliente=Gallery4.Selected.Result)
For you, it should be:
Filter(WorkOrder ,jobaddress =Gallery4.Selected.Result)
Refer to above solution and do changes based on your actual needs.
Best regards,
Allen
tbabe12 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for this..
tbabe12 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for helping out, i just realized it isn't working for all of my address.. just wondering why it is selecting what to count. if you look at my screenshots, the 212 have repeated rows but it won't count it. it works well for the 187 address.. what do you think might be the issue?
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tbabe12 ,

The information is rather limited, I cannot tell you why this happen.

Please provide some more information about the formula you are using(better with screenshots).

Best regards,

Allen