cancel
Showing results for
Did you mean:

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

Frequent Visitor

## DAX calculation from two "sub" - tables

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.
Thank you!
1 ACCEPTED SOLUTION
Community Champion

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:

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!

5 REPLIES 5
Community Champion

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:

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!

Frequent Visitor

Thank you @TheoC it worked.

Regards,

Priyanka

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!

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.

Frequent Visitor

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.

Regards,
Priyanka

Announcements

#### Power BI Monthly Update - November 2023

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

#### Fabric Community News unified experience

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

#### 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