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.
The Filtering of the Segments doesn't work yet. If you put a slicer on your canvas with Segment_F_2 = b you filter Facts 2 but not the Facts 1 table. The dates seems to work. I additionally want to filter the Segments. They have in both tables the same meaning.
it's correct behaviour because power bi knows only about Date relationships.
do you want to use both relationships by Date and Scenario at the same time?
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.