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 created a table called Calculator Power Query that contains 2 fields (M2, M3) containing a series of values from 0 to 95, incrementing by 5.
I am using 2 filters in the report: one that points to column M2, and one that points to column M3.
I want to filter M2 and with a measure get the maximum value of that filter, avoiding all the filters that may be in M3.
The problem is that I can't avoid filtering M3. Check this image, my metric should return 55, but it is returning 45 (the maximum value in M3):
I can not use the option Edit Interactions between visuals, since my intention is to create another measure based on M3 (that at the same time should avoid M2), and then compare M2 and M3 on the same chart.
Here is my metric:
Solved! Go to Solution.
I've found the reason behind this behaviour and it is related to auto-exist mechanism applied by DAX when there are 2 or more filters operating over the same table.
Refer to this article from sqlbi for better understanding of this: https://www.sqlbi.com/articles/understanding-dax-auto-exist/
I've found the reason behind this behaviour and it is related to auto-exist mechanism applied by DAX when there are 2 or more filters operating over the same table.
Refer to this article from sqlbi for better understanding of this: https://www.sqlbi.com/articles/understanding-dax-auto-exist/
Could it be related with the auto-exist mechanism? I foun an article from SQLBi related to this.
what about change the visual interaction and set to no impact?
Proud to be a Super User!
Please read my post: I can not use the option Edit Interactions between visuals, since my intention is to create another measure based on M3 (that at the same time should avoid M2), and then compare M2 and M3 on the same chart.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |