Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
You may refer to the blog below about how to use OR condition between multiple slicers:
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
88 | |
49 | |
45 | |
38 | |
37 |