Forum Discussion
Add grouping using DAX
Hi all, I have columns: Store name Coleague name Sales And want to create table that includes only: Colleague name total sales for Store I don't want to add extra column for Store...
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 ,
See if this will meet your requirements
You can refer to the pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have managed to do this very similar way already. As per my post earlier.
Thanks for reply anyway and have a good day
daniel
- Hi Anonymous ,It's glad that you have solved your problem.
You can share the link and accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.