Sum ( or Total) of a value based on 2 drop down list

(0) Share

Report

Posted on by Manny123

158

Hi Team,

Was wondering if someone could help.

I have a Powerapp Canvas app which records the number of IT Tickets raised by employees.

I have 2 dropdown lists - 1. One which filters on Department Names and 2. which filters on team names in the department.

e.g. Dropdown1 (Department Names ) - Department A, Department B

Dropdown2 (Team Names) - Team A, Team B, Team C, Team D

I have a label next to the 2 dropdowns. The label counts the number of tickets raised.

I need the label to COUNT the number of tickets raised AS DEPENDING ON THE DROPDOWNS SELECTED.

I.e. If on the first dropdown Department A is selected then it would show ALL Tickets related to Department A.

If user then Department A and then Team A - it will show total number of tickets raised ONLY for Team A.

I have had a go but the formula is only works when Dropdown 2 is selected.

CountRows(Filter('TicketsRaised', ('Team Level'.Value=Dropdown2.Selected.Value)))

I need it work so if Dropdown1 is selected and Dropdown2 is blank() (ie not selected) show all tickets at Dropdown1.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

PTBBSolutions 691 on at

Like (0)

Report
Hi @Manny123 ,

Maybe you can try something like this:
CountRows( If( !IsBlank(DropDown1.Selected.Value), Filter( TicketsRaised, YourColumn = DropDown1.Selected.Value ), Filter( TicketsRaised, OtherColumn = DropDown2.Selected.Value ) ) )

Was this reply helpful? Yes No
Manny123 158 on at

Like (0)

Report

Hi PTBBSolutions,
Thanks for the reply.

What I need is by default if no dropdowns are selected - to show all tickets raised.
Then if Dropdown1 and or Dropdown2 is selected the total will adjust to reflect the dropdown selections.

Was this reply helpful? Yes No
Verified answer

PTBBSolutions 691 on at

Like (1)

Report
Hi @Manny123 ,

Just add one more condition:
CountRows( If( Isblank(DropDown1.Selected.Value) And Isblank DropDown2.Selected.Value), TicketsRaised, If( !IsBlank(DropDown1.Selected.Value), Filter( TicketsRaised, YourColumn = DropDown1.Selected.Value ), If(!IsBlank(DropDown2.Selected.Value), Filter( TicketsRaised, OtherColumn = DropDown2.Selected.Value ) ) ) )

Was this reply helpful? Yes No
Manny123 158 on at

Like (0)

Report

Hi
Many thanks for the replies. Much appreciated.
I am getting errors messages when using the code above and replacing the dropdown1 and 2 names with mine.

Not sure if this will help but I created dropdown 1 and dropdown 2 using the formula below:

In Items: Dropdown1
[Blank(),"Department A", "Department B"]

In Items: Dropdown2
[Blank(),"Team A", "Team B", "Team C"]

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

What is the error you are receiving?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Manny123 ,

If you are using Dropdown Controls, please try and change the "Allow Empty Selection" property to true instead of using Blank() in the Items.

If you are using Combo box Controls, by default it could accept empty selection so Blank() is not necessary as well.

I could not found any wrong in @PTBBSolutions 's codes except missing an opening parenthesis at line 3. If you have solved the issue with his codes, please consider accept that reply as the solution.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni

Was this reply helpful? Yes No
Manny123 158 on at

Like (0)

Report

Hi
For some reason(s) the formula above is not working for me without giving errors. I am clearly doing something wrong on my side which I will carry on checking. I am happy to close the ticket as the syntax provided has been verified.

Thanks.

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Hi @Manny123 ,

What is the error which you are receiving?

Was this reply helpful? Yes No