- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to get slicer AND condition when tables are not directly related
Hi all,
EDIT: I've solved it using https://community.fabric.microsoft.com/t5/Desktop/Slicer-with-AND-condition-in-Power-BI-instead-of-O... but the default view of the table when none of the slicers are selected are for personnel who have done all 6 courses. How do I change this so it shows all the data instead?
DAX Measure used:
I applied the measure to the table so it shows items when the measure isn't blank. The measure works if I select multiple courses:
But when none of the slicers are selected the default view shows personnel who have done all 6 courses whereas I would like the default view to show all the data.
Currently:
Goal:
Previous information for context:
I'm trying to solve an issue where I would like to see personnel in the company who are qualified for multiple courses however the default slicer selection uses the "OR" condition. I've found a few solutions online https://radacad.com/slicer-with-and-condition-in-power-bi however I can't seem to get this to work since the tables aren't directly related. Below is the sample data:
Course table:
Reference table:
I split this column via delimitir into separate rows:
I also created a definition table:
The relationship between the tables:
Currently the slicer works if I'm just selecting one value:
I would like the slicer to work so that when I select Course 1 and Course 2 I can see only names of people who have done both courses however right now it's showing people who have done either Course 1 or Course 2.
I've also attached the Sample Data and PBIX. Help.pbix Sample Data.xlsx
Thank you!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Xairan
Thanks for the reply from Thennarasu_R .
@Xairan , the following testing is for your reference.
Create another measure as follows
condition1 =
VAR _countSelected = CALCULATE(COUNT(Definition[Course]), FILTER('Definition', ISFILTERED(Definition[Course])))
return
IF(_countSelected = 0, 1, IF(_countSelected = [condition], 1, 0))
Put the condition1 into the visual-level filters, set up show items when the value is 1.
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Xairan
Thanks for the reply from Thennarasu_R .
@Xairan , the following testing is for your reference.
Create another measure as follows
condition1 =
VAR _countSelected = CALCULATE(COUNT(Definition[Course]), FILTER('Definition', ISFILTERED(Definition[Course])))
return
IF(_countSelected = 0, 1, IF(_countSelected = [condition], 1, 0))
Put the condition1 into the visual-level filters, set up show items when the value is 1.
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Awesome - thanks for that! Worked perfectly 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Xairan
Can you explain the little brief your scenario as well Can send your exception output with dummy data in excel from below attcahed SS.
Thanks,
Thennarasu R
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey,
I've attached the files here Help.pbix Sample Data.xlsx
I've actually solved the first section myself - finding out who has done multiple courses selected however just trying to find out how to have the default view showing all the data in the table instead of everyone who has done all courses.
Thank you!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-02-2024 11:48 AM | |||
07-10-2024 08:08 AM | |||
Anonymous
| 05-05-2024 09:23 AM | ||
Anonymous
| 08-22-2024 10:38 AM | ||
08-03-2022 04:34 AM |
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |