Forum Discussion
Dimension Relationship Problem
I have a model like below. Dimensions: Project Code Building Code Area Location Fact: HLC NCR Report Building Code, Area and Location has no relation between them. They only h...
Anonymous,
You may apply virtual relationship in DAX measure.
https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
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?