Forum Discussion
data model dont work
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.
yes at the end i will compare the values in a table. if i filter the segment the values should have the same dates and the same segment 😕 i dont want to use a separate segment filter for table Facts 1. that should passoible or?
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!