Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to understand how ISFILTERED and ISCROSSFILTERED work with respect to a date column from the date table.
in the screenprint below, the value in the ISCROSSFILTERED field returns true when I choose any Month from the Slicer. Yet even though it's a direct filter, the ISFILTERED measure doesn't change.
Measures:
In another scenario, I added both measures to the same table visual, and the ISCROSSFILTERED now returns true, whereas the same in the card visual outside has not changed.
The only time the value of the ISFILTERED field changes is when the Date column in the table's visual is changed to just the Date from Date hierarchy.
This is extremely perplexing, and I feel as if I won't be able to continue my Power BI learning journey until I completely understand these basic concepts.
Please enlighten me.
Thank you in advance.
Hi,
you ask good questions and you go a important step to understand DAX . I try to explain it: At first ISFILTERED(COLUMN) give back "true", if this column is directly filtered e.g. by a slicer. ISCROSSFILTERED(COULMN) give also back "true" if a filter from a another column has a effect to this column.
1)
In your first screenshot you filter the monthname column via the a slicer (July), so this is correct:
Proud to be a Super User!
I really appreciate you taking the time to explain this to me. While I'm still not completely clear on the logic, your explanation has definitely brought me closer to my desired understanding
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |