Forum Discussion
Relationship!
Hi,
if the relationship is not active.
things in my report don't work properly..?
i've made relationship like below.
but still the table doesn't work properly.
In the table, I took module from DP list. and the rest from start/ finish plan and actual.
the figures are not correct..?
i feel like if the relationships become active, it'd be all ok.
or i need to make some measure or table?
Hi Anonymous
I would consider this as poor data model design.
Your data model is full of bi directional relationships. You can use Power Query to denormalize your tables to achieve the desired output. Relying too much on Relationships and DAX is the worst design practice and should be avoided.
As I mentioned earlier, You can use USERELATIONSHIP function to convert the inactive relationships to active relationships.
Please check out the sqlbi blog article on this topic:
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/