Forum Discussion
Dimension Relationship Problem
Anonymous,
You may apply virtual relationship in DAX measure.
https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
Hello Anonymous!
if you get rid of the bi-directional filter (highly suggested) then the 'Project Code' dimension will filter the fact table but then the fact table does not filter the other three dimensions (giving you the effect that you want).
Also notice that there are columns in the fact table that you do not need anymore and can be removed to make your model lighter, for instance 'Area', 'Location', 'Building Code' are all attributes of the three dimensions so they can go and probably there're a few more like this
Thanks LivioLanzo;
Yes I understand, I will clear the columns.
I don't want both sided becuse they want to see the zero values also. For example, All the Locations, that project A has. If I build a both sided relation to the fact, fact also filter the Location table. So I can not see the Location which havent got a value on the fact.
But they want to know all Locations, for asking why there is no transaction to this Location.
In this case, I tried many relationship scenarios, but I couldn't solve.
Hi Anonymous,
try with the bi directional filter removed and also on your matrix you can enable 'Show items with no data'
Thats ok LivioLanzo. But when I remove bidirectional Project Code can not filter Building, Location, Area Tables. How can we handle this?