Merge multiple filters

(0) Share

Report

Posted on by AmeliaDwight

hi everyone,

i have a table with items as:

Filter( Tracks, Retailer = 'Retailer (Tracks)'.Amazon )

I also have a text box with the total number dependent on some filters via dropdowns.

Text(Sum(Filter(Tracks,And(Or(IsBlank(ComboBox1_4.SelectedItems),IsEmpty(ComboBox1_4.SelectedItems),Market in ComboBox1_4.SelectedItems),Or(IsBlank(ComboBox1_10.SelectedItems),IsEmpty(ComboBox1_10.SelectedItems),'Pitch Status' in ComboBox1_10.SelectedItems),Or(IsBlank(ComboBox1_9.SelectedItems),IsEmpty(ComboBox1_9.SelectedItems),'Campaign ' in ComboBox1_9.SelectedItems))),'Trade Q2'),"0","en-GB")

How do i merge these together so that the total is only amazon, dependent on the filters?

Thanks so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

bengo83 159 on at

Like (0)

Report

Hi @AmeliaDwight

Do i understand you correctly? Do you want to filter the results of the second filter according to the criteria from the first filter?

King regards
Beny

Was this reply helpful? Yes No
Verified answer

AmeliaDwight 92 on at

Like (1)

Report

Hi @bengo83,

i realize the confusion!
This is what i needed!!

Text(Sum(Filter(Tracks,Retailer = 'Retailer (Tracks)'.Amazon, And(Or(IsBlank(ComboBox1_4.SelectedItems),IsEmpty(ComboBox1_4.SelectedItems),Market in ComboBox1_4.SelectedItems),Or(IsBlank(ComboBox1_10.SelectedItems),IsEmpty(ComboBox1_10.SelectedItems),'Pitch Status' in ComboBox1_10.SelectedItems),Or(IsBlank(ComboBox1_9.SelectedItems),IsEmpty(ComboBox1_9.SelectedItems),'Campaign ' in ComboBox1_9.SelectedItems))),'Trade Q2'),"0","en-GB")

Was this reply helpful? Yes No