Forum Discussion
Related Table grouping sum
I'm using some related tables to create a report, the left most table has the values sold, and the right most table has the information which I want to group by. Power bi isn't able to create the sum...
I forgot to mention I activated the following options:
File > Options and Settings > Options > DirectQuery > Allo unrestricted measures in DirectQuery mode
LaurentCouartouI believe that only makes those restricted functions available for measures, and vitinho is trying to use them in columns. I don't think that option will help here.
You are right, that is why I suggested writing a measure in my previous post.