The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |