Forum Discussion
Related function not working
Hello everyone, I have looked at many posts related to this issue but have not been able to find a solution. We have a 1:* relationship between 2 tables. The table on the many side of the relat...
To be honest, I am NOT surprised that this is a limitation in Power BI.
Think about it.
It's like if you were going to bake a cake and you go to the store to get eggs, milk, and flour. You could ask the store clerk, "how much are your eggs?" and they would tell you BECAUSE THE EGGS ARE IN THE SAME STORE.
But if you ask, "How much are the eggs in the store across the street?" The clerk can't answer that question.
IMPORT mode is data IN THE SAME STORE.
Direct Query is data IN THE STORE ACROSS THE STREET.
That not a very helpfull remark.
This is what I found which is a lot more helpfull:
- The current relationship is not active.
- The current relationship is a many-many relationship or limited relationship.
- The current relationship is configured with an incorrect column.
- The current relationship is a many-one relationship and you are trying to use the RELATED function in the Lookup table, not in the Fact table.