Dimension not showing value when the measure is being added to table
I have 3 table - Fact , Dimension 1, Dimension 2 with keys and relationships as defined in the table.
Requirement: I want to have a table visual with sales,name, details and I want name , sales value to always display even if key1 is not found in Dimension2 table. Can someone please help here? So far, if I am creating a table, I am getting no rows when I am adding details column to the table and the key1 is not present in Dimension2 table.
Please help me !!! Attached is a sample file :- PBI File