DAX calculation from two "sub" - tables

[mallap849]

"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!

@TheoC  @ppm1 

[TheoC · Accepted solution]

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:

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

Hope this helps.

Theo

[mallap849]

Thank you @TheoC it worked.

Regards,

Priyanka 

[TheoC]

Really glad it worked for you, @mallap849!

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

[amitchandak]

@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.

[mallap849]

"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