Forum Discussion
Helper IVMerging tables with large numbers of rows
There's a typo in your expected result - g is appearing 10 times not 9 times. So the total is 911, not 902.
You may want to try TREATAS as an alternative, it will likely perform better with larger data sets
Helper IVOK I now have a really good understanding of how this all works. Many thanks I wouldn't have got there without you.
I do have one issue - I would like to know if I can create a table of distinct values within the SUMMARIZECOLUMNS formula. Due to how my real data is, I don't really have a GROUP table equivilant with a distinct listing of groups. Due to the fact creating this in PQ would have a lot of overhead due to the volume of data, I was hoping I could do something like:
SUMMARIZECOLUMNS(DISTINCT('Group Item Values'[Group]),'Group Item Values'[Item],
Doesn't work though. If I just do the DISTINCT bit, I can see it indeed creates a table with distinct Group values, but I can't work out how to use this within the SUMMARIZECOLUMNS formula. I tried assinging it to a variable but that didn't work either. Thanks!!
- lbendlin
Super User
SUMMARIZE and SUMMARIZECOLUMNS already do the grouping for you. There is no need for DISTINCT.
You can assign tables to variables but your measure eventually needs to return a scalar value.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.