Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have data as follows, and it can be downloaded here:
application id | province | employer | citizenship | company | institution |
1 | Ontario | B | canada | A | B |
2 | Yukon | C | France | B | D |
3 | Alberta | A | Australia | C | E |
4 | Manitoba | C | US | D | F |
5 | British Columbia | A | US | A | F |
6 | Ontario | B | canada | B | A |
7 | Ontario | C | canada | C | A |
8 | Quebec | C | Australia | C | B |
9 | Quebec | D | Australia | D | C |
10 | PEI | A | France | B | D |
11 | Alberta | A | Australia | B | E |
12 | Alberta | D | India | A | F |
13 | British Columbia | D | India | D | F |
14 | Alberta | C | canada | C | C |
15 | Saskatchewan | D | India | B | A |
16 | Yukon | B | India | A | B |
17 | Ontario | B | Australia | B | B |
18 | Quebec | B | France | C | D |
19 | Quebec | C | US | D | C |
20 | Ontario | A | US | D | C |
I have slicers for all of these columns and I have charts with application volumes. How can I get the tables to represent the number of applications with the following criteria:
Province: Ontario
OR
Employer: C
OR
Country: US
OR
Company: B
OR
Institution: F
where those are slicer selections.
Thank you
For fun and to show off the power of Excel,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @sheap069 ,
Be default and by definition, slicers are used to slice the data and work with the 'AND' logic in Power BI. You can change the interaction in the slicers to show all the values but in the table if they are coming from the same table, the slicers will 'filter' the data in the 'AND' condition.
Refer: Solved: Power BI slicer OR condition - Microsoft Power BI Community
Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |