Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

grouping using dax

Hi Experts, So i have a few tables that i want to group by using Dax because i cant do it in query as there is 1 mesure column that i want to use and cant be found when im in power query.  I ha...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

Hi Anonymous ,

I'm a little confused by your description,.First, you need to know that the GROUPBY function returns a table, so when you use GROUPBY, you create a table.
In addition, the table "Ldet" and the table Supplies/Lab do not seem to have a relationship, so you can't get the correct value you want. Could you share your expected output, it would help tremendously.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-joesh-msft 

 

Hi here's the link (i will just delete it later on)

I'm using the page 2 and page 1


So my outcome (so that it wont be confusing) that i want is :
From table "LDet3" get the BR and Chassis sum them all up by the measure that i created which is "total lab$".
Note that "total lab$" is from another table which is "BR"


Thank u for helping.

  • v-joesh-msft's avatar
    v-joesh-msft
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi Anonymous ,

    I guess if you are expecting this result:

    Create a new table and use the GROUPBY formula：

    Table = GROUPBY(LDet,LDet[BR],LDet[Chassis],"Labour",SUMX( CURRENTGROUP(), LDet[Lab]+ LDet[Supply]) )

    Here is a demo, please try it:

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQYd-ayZ_lNFtfHYuhmFPrMBhdW2BqxE6zD_gpJjiw3Hqw?e=yJTztS

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-joesh-msft 
      Hi thank you so much for the help, I appreciate it! I tried the method but it turns out this:
      from what i know there is a relationship between my tables. so if there is a relationship this shouldn't show this on the table.


      here's my formula that i follow: (this whole table is from LDet3)


      here's my relationship: (there is no relationship between "table" and "LDet3" i tried to but it only shows me many to many rel)


      not really sure what is happening 😞