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


 

Need Help

4 Replies

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution 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.