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/
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?