- 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
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 :
When I try to add for the previous visual, columns from Employees VIP :
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 :
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 :
@AmiraBedh regarding VIP table, I see it has one to many relationship, do you expect more than one record for employees, although TIC is 1 to 1
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
If I change the relationship to 1 to 1 it gives the expected result, but I cannot change it in the real model as it is 1 to many. Any workaround ?
@AmiraBedh so I reviewed the queries and the engine is doing different queries when you move the column positions in the visual:
Basically this part of the query is different in both the case and causing the result:
//showing tic then vip
// DAX Query
DEFINE
VAR __DS0PrimaryShowAllCompat =
//
// CALCULATETABLE(
// GENERATEALL(
// KEEPFILTERS(VALUES('Employees'[EmpName])),
// CALCULATETABLE(
// GENERATEALL(
// KEEPFILTERS(VALUES('Employees'[EmpLastName])),
CALCULATETABLE (
GENERATEALL (
KEEPFILTERS (
FILTER (
KEEPFILTERS ( VALUES ( 'Employees TIC'[Status TIC] ) ),
OR (
CALCULATE ( NOT ( ISEMPTY ( 'Employees TIC' ) ) ),
CALCULATE ( NOT ( ISEMPTY ( 'Employees VIP' ) ) )
)
)
),
CALCULATETABLE (
FILTER (
KEEPFILTERS ( VALUES ( 'Employees VIP'[Status VIP] ) ),
CALCULATE ( NOT ( ISEMPTY ( 'Employees VIP' ) ) )
)
)
)
) // )
// )
EVALUATE
__DS0PrimaryShowAllCompat
//vip first then tic
// DAX Query
DEFINE
VAR __DS0PrimaryShowAllCompat =
// CALCULATETABLE (
// GENERATEALL (
// KEEPFILTERS ( VALUES ( 'Employees'[EmpLastName] ) ),
CALCULATETABLE (
GENERATEALL (
KEEPFILTERS (
FILTER (
KEEPFILTERS ( VALUES ( 'Employees VIP'[Status VIP] ) ),
CALCULATE ( NOT ( ISEMPTY ( 'Employees VIP' ) ) )
)
),
CALCULATETABLE (
FILTER (
KEEPFILTERS ( VALUES ( 'Employees TIC'[Status TIC] ) ),
CALCULATE ( NOT ( ISEMPTY ( 'Employees VIP' ) ) )
)
)
)
) // )
// )
EVALUATE
__DS0PrimaryShowAllCompatSubscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@AmiraBedh Very hard to reach, I wish you had put that as the code. Can you share the sample pbix file to look into it?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@AmiraBedh that's interesting. Can you get the DAX query for both cases using a performance analyzer to see what is happening behind the scenes.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
