Forum Discussion
Solved
Relationships in data model does not work - breaks table visual
Hi, I have a pretty simple data model, which consists of 3 tables: * property table * measures table (one property can have multiple measures) * installation works (one property can have mu...
Hi mtomova ,
I wanted to check if you have had an opportunity to try the bridge table approach.
Best practice: Keep star schema → use property_table as dimension, and show measures/installation separately.
If you need both in one row → create a bridge table (property_id, measure_id, task_id).
If you just need to show related fields → use DAX (LOOKUPVALUE / TREATAS).