Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Percentage between 2 columns in 2 tables

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 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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]) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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