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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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