How do I add a table visual using filtered values from multiple tables?

[Anonymous]

I have a table visual with data from multiple (5) tables. I need to create one table that contains filtered data from each table. The filtering must all be using "or" not "and". 

Here is a sample of my data:

Parent Account	Child Account	DDD Percentile June	PPP June	May Touch Points	May Cases	Submissions
ABC	REG	25	14.23		3	0
DEF	MFG	95	28.2			345
XXX	AHA	64	36.2	2		98
CCC	MCA	45	15.2			0
DDD	RWA	22	16.0			25
GGG	RHB	100	18.23		1	189
TTT	RHP	88	25.23			78
JJJ	JHJ	78	18.9	3		65
OOO	CHH	63	23.2			0

I need to create a table visual that displays the following: 

Any Parent or Child account where DDD Percentile June is less than 80

or Any Parent or Child account where PPP June is greater than 16.6

or Any Parent or Child account where May Touch Points is blank

or Any Parent or Child account where May Cases is blank

or Any Parent or Child account where Submissions is equal to 0

[v-yuta-msft]

@Anonymous ,

You may refer to the blog below about how to use OR condition between multiple slicers:

https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/#:~:text=By%20default%2C%20when%20relying%20on,in%20a%20logical%20AND%20condition.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, thank you. However, I am a novice user and do not know DAX. I need the specifics as applies to my data if I am going to use DAX.