grouping using dax

[Anonymous]

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 have Ldet(3) that i want to group by with BR and Chassis and Use the other table which is BR to sum everything by measure "Total Lab$" that i created already .


I have this formula but its wrong 😞 :


need help pls. Prefer to have an outcome in .pbix 😞

[v-joesh-msft]

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]

@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]

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]

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