Forum Discussion
Bidirectional Relationships crossfilter?
Hello!
I need some help with my model.
This is how it looks:
I need to be able to make a calculation with values from the accidents table and then slice it by using slicers from the BO_FACTORY...-table and the Calendar-table.
How do I do that?
This is the message I get when I try to make the relationship active:
Thank you for helping me!
UPDATE:
I tried this:
But it still didn't solve my problems. I get the same value on en each entity
Hi Anonymous ,
There's a problem with the relationship between the tables, as you said you want to slice it by using slicers from the BO_FACTORY...-table.
Then there needs to be a relationship between BO_FACTORY table and accidents table. But there may be something wrong with your model design. It is recommended that you filter the values by creating conditions.
For example:
Measure = IF(MAX(accidents [entitycode]) in VALUES(BO_FACTORY[entity]),1,0)Create such a measure and put it in the visual level filter to filter the values through the slicer.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , Why Accident table has many to many join with date table. If it has month/Qtr level data. Then create a month or qtr start date and join on that date with date
I explained where show to convert them to dates
V-lianl-msftCommunity Support
Hi Anonymous ,
There's a problem with the relationship between the tables, as you said you want to slice it by using slicers from the BO_FACTORY...-table.
Then there needs to be a relationship between BO_FACTORY table and accidents table. But there may be something wrong with your model design. It is recommended that you filter the values by creating conditions.
For example:
Measure = IF(MAX(accidents [entitycode]) in VALUES(BO_FACTORY[entity]),1,0)Create such a measure and put it in the visual level filter to filter the values through the slicer.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
