Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey, guys,
I hope this one is not a too dumb one 🙂 I am figuring out how cross-filtering works. I am trying to cross filter the table visual by cross by axis values from above. If I press Pirmas 100, I want to see the only those 4 leads, but it doesn't work. What am I doing wrong? Does cross-filtering only work for whatever is in the axis, but does not include the filters that are inside the measure? attaching desktop file:
https://drive.google.com/file/d/1CO76sAf3B9X6cf5P2Af8oU-OmeOxy5y7/view?usp=sharing
Thanks 🙂
Solved! Go to Solution.
Well first of all there is no dumb question, Cross Filtering confuses many of us due to ambigiuty of its nature.
You can go thru with this article which explained in better words about Bi-directional filters and ambiguity
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Proud to be a Super User!
HI @Almantas32,
Maybe you can take a look at the following link to know more about as tabular model relationship design to change your relationship mapping to use bridge and key table as core to link different tables.
Relationships in analysis services tabular models
Regards,
Xiaoxin Sheng
@Almantas32 , check if this can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Well first of all there is no dumb question, Cross Filtering confuses many of us due to ambigiuty of its nature.
You can go thru with this article which explained in better words about Bi-directional filters and ambiguity
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
75 | |
51 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |