Forum Discussion
Solved
Understanding summarizing order lines
Hello, I am rather new to Power BI and I am missing something elementary. I have a table with a lot of order lines and several dimensions (date, region, item category, item characateristic 1...
I solved it. I'm stupid. I was so convinced all relations were OK, .. BUT there was a relation indicated as "not active". I simply clicked it, and it worked. I don't know why it was not active.
Power BI is going to aggregate rows as much as possible. If you want to see individual lines, then the lines need to have all the fields that represent a unique row. This is most easily achieved if you have distinct key or index for each row that you include in your visual