Forum Discussion
Problem with data model and establishing relationship after unpivoting columns
Community SupportHi, Maciek_ ;
You could create a measure as follows:
Measure = CALCULATE(MAX([Value]),FILTER(ALL('Append and unpivot - Lversion + Env'),[Type]=MAX([Type])&&[Value]=MAX([Value])))
The final output is shown below:
If not ,can you share me the result what you want to output?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi again v-yalanwu-msft I am afraid that is not at all what I need 😞 the expected output is shown on one of the screenshots above and also here again
In small table I should see the details of the activities based on the selection (filtering) from bigger table - if I select a row in a bigger one, the small one should display attributes taken from Env details table based on selected "Env.ID" in the first column and attributes taken from Lversion details table based on selected "Lversion.ID" in the second column.
lbendlin I tried using Dep details table as a fact table as well but for both this table and Env details table Lversion.ID can be repeated so relationship between these cannot be other than many to many...
- lbendlin
Super User
You can get away with Many-to-Many relationships as long as you use a single filter direction.
