Forum Discussion

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago
Solved

Implementation of Left Join Scenario in Table Visual

Below is my scenario :

Fact table :

 

Dim table :

 

There is 1:1 relationship between the dim and the fact table.

 

Now my requirment is to display all the columns and rows from dim table and the sum of hour for the the coressponding join if any else blank for the latest month.

 

Output needed in table visual:

MonthCd ,EmpId,Gender,Country,Hours

20240301,1,M,USA,8

20240301,2,F,UK,blank (or even 0)

20240301,4,,UK,7

20240301,5,M,India,9

 

But when I pull in the measure of sum of hours from the fact table in the dim data, as ROw with ID 2 is not present in fact for the latest month, hence the dim row also gets filtered out

 

So how to retain the row when there is no fatual data assoacited with it be replacing it with blank/null/default value?

 

Have attached sample PBIX file for reference

 

 

  • Hi NandanHegde ,

     

    In this case you only need to go to the visualzation and select the show items with no data option:

     

     

     

1 Reply

  • Hi NandanHegde ,

     

    In this case you only need to go to the visualzation and select the show items with no data option: