Forum Discussion
unnijoy
Post Prodigy
Post ProdigyDimension tables not filtering each other
Hi All, I have a fact table and two dimension table. Dim Table 1 got the name of country and it is mapped to Fact table "Coutry". (Many to One). Dim Table 2 got the managers name. and is mapped to F...
Hello, unnijoy
That's kinda the correct behavior, since Dimensions by design are usually OneToMany with a single cross filter. So they only filter the Fact table, not other dimensions.
If you want them to filter each other check this link:
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
vojtechsima
Super User
Super UserHello, unnijoy
That's kinda the correct behavior, since Dimensions by design are usually OneToMany with a single cross filter. So they only filter the Fact table, not other dimensions.
If you want them to filter each other check this link:
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
- unnijoy
- vojtechsima
unnijoy
You're welcome, leave a message here if the solution will work for you.
