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...
Hi, thanks for the help. But Summarize function don't appear for me either. any ohter idea what this could be?
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.