topic Re: Percentage betwen two tables in DAX Commands and Tips

Percentage betwen two tables

dofrancis3 — Wed, 12 Feb 2025 09:42:42 GMT

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

Re: Percentage betwen two tables

bhanu_gautam — Wed, 12 Feb 2025 10:03:37 GMT

dofrancis3 Try using

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

Re: Percentage betwen two tables

dofrancis3 — Wed, 12 Feb 2025 10:29:30 GMT

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.

Re: Percentage betwen two tables

vivek31 — Wed, 12 Feb 2025 10:31:18 GMT

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

Re: Percentage betwen two tables

bhanu_gautam — Wed, 12 Feb 2025 10:40:52 GMT

dofrancis3 , Use it direct than

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

If you still face issue share PBIX or sample data

Re: Percentage betwen two tables

dofrancis3 — Wed, 12 Feb 2025 11:02:14 GMT

Dear vivek31 thank you so much for your support