cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
mallap849
Frequent Visitor

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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 

 

TheoC
Community Champion
Community Champion

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors