Forum Discussion
Solved
data model dont work
Hi all, I have the following Data Model: When I filter the Facts 2 table with Segment_F_2 = B it has no influence to the Facts 1 table (Value_F_1 dont change). Does someone has an idea ...
your solution seems to work. many thanks for your effort 🙂
i have now again false values but the reason is an another one i thinks.
No in just one direction at the moment. Segment_F_2 should filter Facts 1. But maybe it is possible with a Facts 3 table that connects the segments? Maybe i should try it again.
It didnt work. Is it maybe with a measure possible? 😪
my idea is to create surrogatekyes calculated columns in both of Fact tables
SurrogateKey_1 = CONCATENATE(FORMAT([Date F 1], "YYYYMMDD"), [Segment F 1])AND
SurrogateKey_2 = CONCATENATE(FORMAT([Date F 2], "YYYYMMDD"), [Segment F 2])then delete relationships with calender table and create relationships SurrogateKey_1 - SurrogateKey_2
see attach
your solution seems to work. many thanks for your effort 🙂
i have now again false values but the reason is an another one i thinks.
thats great, good luck!