Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aafflick
Frequent Visitor

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

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 AccountChild AccountDDD Percentile JunePPP JuneMay Touch PointsMay CasesSubmissions
ABCREG2514.23 30
DEFMFG9528.2  345
XXXAHA6436.22 98
CCCMCA4515.2  0
DDDRWA2216.0  25
GGGRHB10018.23 1189
TTTRHP8825.23  78
JJJJHJ7818.93 65
OOOCHH6323.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

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@aafflick ,

 

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%2...

 

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.

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. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.