Forum Discussion
vitinho
Helper I
Helper IRelated 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...
vitinhoHelper I
Helper IHi, thanks for the help. But Summarize function don't appear for me either. any ohter idea what this could be?
LaurentCouartou
Solution Supplier
Solution SupplierI 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.
- LaurentCouartou
You are right, that is why I suggested writing a measure in my previous post.