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
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 😞