powerbidaxpowerbi-desktopdata-modelingssas-tabular

Show items with no data is not giving expected result


I am using a Live connection to an SSAS tabular model having the following tables :

Employees : all Employees in the company

Employees VIP : Employees having the status of VIP in the company

Employees TIC : Employees having the status of TIC in the company

The relationships between the tables :

Employees - Employees VIP : 1 to many , filter in both directions based on EmpID

Employees - Employees TIC : 1 to 1 , filter in both directions based on EmpID

enter image description here

I am using in a visual columns from the 3 tables :

Employees : EmpID, EmpName, EmpLastName

Employees VIP : Status VIP

Employees TIC : Status TIC

I have this visual where I use data from Employees and Employees TIC :

enter image description here

When I try to add for the previous visual, columns from Employees VIP :

enter image description here

Now I want to show all the Employees, either they belong or not to any VIP or TIC so I selected Show items with no data :

enter image description here

When I try to change the order of the Staus VIP to be before Status TIC :

The display of data changes for the Employees E,F, G and H, I can"t understand this behaviour :

enter image description here

Link to the file : https://drive.google.com/drive/folders/1-rk-VKwYrGdbY7q_cjk_3TlBbAtH3U-H?usp=sharing


Solution

  • I think the answer to this is here: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

    It's important to note that the mechanism of selecting values for the columns is order-dependent, and can be thought of as a Left outer join operation between tables. If the order of the columns is changed, the results change as well.