Data Model Question

[Lily36876]

I have a dimension table named "Store List" that is linked to both the sales details line and the store sales target table.

However, in the past few days, when I use the fields from the "Store List" dimension table and the sales details to create a pivot table, some stores are missing data.

I discovered that this is because they do not appear in the store sales target table.

The perplexing part is that my pivot analysis table has no direct connection to the store sales target table whatsoever.

I haven't utilized any fields from the store sales target table.

Is there a setting I might have missed?

Sample1.

Store disconnect with sales target table , and Shop H011 has Last Year Total Sales in 2023

and  my LYTTL DAX is :

LYAMT = CALCULATE('Sales Line'[TTL],SAMEPERIODLASTYEAR('Date Table'[Date]))

Sample2.

Store connect with sales target table , and Shop H011 lost Last Year Total Sales in 2023

because this shop doesn't have sales target.

but in this pivot table, I don't use any columns from Sales Target Table.

Please help me....

In the past, when working with pivot tables, if a field in the fact table had no data, it would typically result in empty cells at most. I have never encountered a situation like this before.

[MFelix]

Hi @Lily36876 ,

What are the connection types you have? Is it 1 to many? Do you have Bidirectional filters turn on?

Can you please provide more context on the model setup.