Percentage betwen two tables

[dofrancis3]

Dear colleagues,

Please i need your help:

I have two tables (T1 and T2)

• In the T1 I have a cumulative Column named “My_Cumul”
• In the T2 I have a Mesure named “Pop_cumul”

So, I would like to calculate the percentage using this formula: “My_Cumul” DIVISE “Pop_cumul”

Please could you help me with the DAX Mesure.

Thank you

[vivek31 · Accepted solution]

HI @dofrancis3 ,
you can use this formula 

percentage = 
var table_cum = SELECTEDVALUE(Show[**bleep**])
var mesure_cum = [**bleep** show]
RETURN
IF(NOT(ISBLANK(table_cum)) && NOT(ISBLANK(mesure_cum)),DIVIDE(table_cum,mesure_cum))

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you

[vivek31 · Accepted solution]

HI @dofrancis3 ,
you can use this formula 

percentage = 
var table_cum = SELECTEDVALUE(Show[**bleep**])
var mesure_cum = [**bleep** show]
RETURN
IF(NOT(ISBLANK(table_cum)) && NOT(ISBLANK(mesure_cum)),DIVIDE(table_cum,mesure_cum))

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you

[dofrancis3 · Accepted solution]

Dear @vivek31 thank you so much for your support

[bhanu_gautam]

@dofrancis3 Try using

DAX
Percentage =
DIVIDE(
SUM(T1[My_Cumul]),
SUM(T2[Pop_cumul]),
0
)

[dofrancis3]

Dear @bhanu_gautam "Pop_cumul" is a mesure of the T2 it's not a Column. The solution you suggested is when there are two columns, but in this case I have Une collone et une mesure.

Please advise.

[bhanu_gautam]

@dofrancis3 , Use it direct than 

DIVIDE(
SUM(T1[My_Cumul]),
[Pop_cumul],
0
)

If you still face issue share PBIX or sample data