cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

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

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
Super User

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!

Helper I

Thank you @TheoC it worked.

Regards,

Priyanka

Super User

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.

Helper I

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