Percentage between 2 columns in 2 tables

[Anonymous]

I need support to Solve an issue I face 

I have 2 table 

1st one has data related to all clients and their source 

2nd table has actual sales sources 

I need to calculate the conversion rate ( count of each source from the second table / count of each source from the first table)

When I tried to do this I made a measurement " I got the wrong percentages, I got the count of each source from the second table/count of all sources from the first one 

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

I already did that, but the problem is I got "count of source/count of total " 

[amitchandak]

@Anonymous , If these two are connected with a common client table you should be able to get % using

divide(Count(Table2[source]),Count(Table1[source]) )