Forum Discussion
Add grouping using DAX
Hi Anonymous
I would use the SUMMARIZE() function to create the table and the SUM() for calculating the sales:
In SUMMARIZE you chose what to group by and then create the measure which we name -> "Sales" and define it by SUM()
Hope this is what youre looking for
Hi Anonymous
I would use the SUMMARIZE() function to create the table and the SUM() for calculating the sales:
In SUMMARIZE you chose what to group by and then create the measure which we name -> "Sales" and define it by SUM()
Hope this is what youre looking for
Hi,
just managed to do this by linking summarized table (grouped by store) to colleague table (store name to store name).
Now when you run it by calleague it will pull total store's sales from summarized table.
Much appreciated
daniel