Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • JohanT's avatar
    JohanT
    6 years ago

    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

JohanT's avatar
JohanT
Frequent Visitor
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

thanks for reply!

This is close to what i want to achive:

The result I am looking for is as below:

 

Jane 30 (total sales for store A - where Jane works)

Jane 160 (total sales for store B - where Jane works)

John 30 (total sales for store A - where John works)

John 160 (total sales for store B - where John works)

John 10 (as he is the only one employe in store C)

John 20 (as he is the only one employe in store D)

 

much appreciated

 

daniel