Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dax grouped by measure and different table

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.  Anyone can help? 😞

 
Need Help

9 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Is there any relationship between Lab ,supplies and LDet? Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-frfei-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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-frfei-msft 
      And yes they all have relationship. Hence that is why i cannot understand why it wouldn't work. not sure whether if to use groupby or what but not sure about the formula. Hope you can help. I really need it 😞 Thank you!

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        To create the calculated column using the formula.

        Column 3 = 
CALCULATE ( SUM ( Lab[Lab$] ), FILTER ( Lab, Lab[BR] = VALUE ( BR[branch] ) ) )
    + CALCULATE (
        SUM ( Supplies[Supplies1] ),
        FILTER ( Supplies, Supplies[BR] = VALUE ( BR[branch] ) )
    )

         

        ]