Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two tables that are related by ID in both directions. I want to filter out rows where Bools[Bool] = TRUE() so I can see rows with Bools[Bool] = FALSE() AND Rows with no related entries in the Bools Table. I should end up with Five Rows 1,2,3,4,5 with two rows filtered out.
I have tried everything I can think of Calculated Columns and Measures and searched high and low on the internet. I am sure the answer is simple but I just can't get it.
My logic is: "If the Names row has a related bool then return the bool value otherwise return false." Then I can simply filter bool is false.
Any help would be much appreciated.
Solved! Go to Solution.
This is due to the crossfilter being both. If I change to single, it works as you would expect. However, my use case doesn't allow for it. Basically, crossfilter both means that a filter on one side of the relationship filters the other side of the relationship. Hope someone has an idea to get around this.
EDIT: Looks like this is intended functionality of the cross filter both. My solution was to filter at the data level. Fortunatley this was an acceptable solution for my use case.
This is due to the crossfilter being both. If I change to single, it works as you would expect. However, my use case doesn't allow for it. Basically, crossfilter both means that a filter on one side of the relationship filters the other side of the relationship. Hope someone has an idea to get around this.
EDIT: Looks like this is intended functionality of the cross filter both. My solution was to filter at the data level. Fortunatley this was an acceptable solution for my use case.
Try right click on one of the columns and check if "Show items with no data is activated", if it is, deactivate it
Thanks activated or de-activated doesn't make a difference.
Hi there!
Have you tried using the filter pane, setting Bool <> BLANK() ?
There are no blanks on the filter pane. I guess this is because it is no data rather than blank.
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |