Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mallap849
Helper I
Helper I

DAX calculation from two "sub" - tables

"C:\Users\priya\OneDrive\Sample File.pbix" 

 

Hello,

 

I am trying to create a variable - 2600PPM which is a basically a division from two sub tables i created. I used the following DAX command - 

2600 PPM = SUM('VP-Warehouse Exp'[2600CC Exp])/SUM(Mileage[2600 Series])
 
But it is not giving me a correct answer.
Please advice.
Thank you!
1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @mallap849 

 

If you cannot get @amitchandak's to work, try to break it down one step further by creating two independent sum measures, followed by the divide.  For example:

 

1. Sum 1 = SUM ( Table1[Column] ) 

2. Sum 2 = SUM ( Table2[Column] )

3. Divide = DIVIDE ( [Measure 1] , [Measure 2] , 0 ) 

 

Your output should be like below:

 

TheoC_0-1683585104641.png

 

Importantly, ensure your column format is value (i.e. Whole Number / Decimal).

 

Hope this helps.

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

5 REPLIES 5
TheoC
Super User
Super User

Hi @mallap849 

 

If you cannot get @amitchandak's to work, try to break it down one step further by creating two independent sum measures, followed by the divide.  For example:

 

1. Sum 1 = SUM ( Table1[Column] ) 

2. Sum 2 = SUM ( Table2[Column] )

3. Divide = DIVIDE ( [Measure 1] , [Measure 2] , 0 ) 

 

Your output should be like below:

 

TheoC_0-1683585104641.png

 

Importantly, ensure your column format is value (i.e. Whole Number / Decimal).

 

Hope this helps.

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Thank you @TheoC it worked.

 

Regards,

Priyanka 

 

Really glad it worked for you, @mallap849!

If at all you get stuck in the future, do not hesitate to reach out. 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

amitchandak
Super User
Super User

@mallap849 , The link you posted above will not work.

 

Yoir calculation should work across common dimesion

2600 PPM = Divide(SUM('VP-Warehouse Exp'[2600CC Exp]),SUM(Mileage[2600 Series]) )

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

"C:\Users\priya\OneDrive\Sample File.pbix" 

 

Hi @amitchandak ,

I have tried to reattach the file and I used the formula - 

PPM 2600 = DIVIDE(SUM('Expense'[2600cc Exp]),SUM('Car Mileage Data'[2600 Series]))
The syntax does not give an error but you can see that the value is not correct.
 
Please let me know.
 
Regards,
Priyanka 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.