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 ha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-frfei-msft 
Hi thank you for the reply again, 

It does work, i follow your formula but the total sum from excel comparing to the Power BI total sum there is a kinda big difference of a number. Not sure if the formula is wrong or ... Sorry about it. 
 

 

i've updated the excel numbers, you my take a look at this . this is till nov 14 2019 data. 
https://drive.google.com/file/d/14jDDZY5cIb2vgsHyidPKbzy5P_LoLnuE/view?usp=sharing



thank you for the help again. 😞

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi everyone, 

I really need some help, on getting my numbers right. 
I have a sample link in excel that i would want to achieve in power bi. In excel, its focuses on the "labour" column formula.
https://drive.google.com/file/d/1_l1P-9ykA_UQcf6gxsUz7l8ndj4gvUXT/view?usp=sharing

I've try groupby but couldn't get my numbers correctly. 😞
So in my power bi I have 2 tables that i want to include in my formula 
1. LDet3 - getting the BR and Chassis
2. BR - getting the measure "Total Lab$"

 

Basically, i wanted to sumifs the total lab , BR, chassis 



Would be nice to have a formula on how to do it.

Thank you