Cross filtering problem

[Almantas32]

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 🙂 

[v-shex-msft]

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

[amitchandak]

@Almantas32 , check if this can help

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[FarhanAhmed · Accepted 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/