cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Group dax with measure and other table

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 

45.JPG46.JPG

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

Thank you

0 REPLIES 0

Helpful resources

Announcements
Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

PVA Community Blog Build Carousel (1) (1).png

What does the community say?

Discover what our community thinks about the announcements at Build 2022.

June 14th PVA AMA Carousel (up on May 25th, take down June 15th) (1).png

'Ask Microsoft Anything' about Power Virtual Agents!

Join the community to ask questions and provide helpful answers about Microsoft's conversational AI and Power Virtual Agents.

Users online (1,592)