Distinct count from another non related table

[MP-iCONN]

I have two tables, one for quotes and one for orders.  Now the only relatable data I can think of is the Branch but just wondering if there is a way to get these two numbers possibly toghether, maybe in a new table if that is needed so I can get percentages of Quotes to Orders.  Thank you for any advice or help on this.

[Avantika-Thakur · Accepted solution]

Hi @MP-iCONN ,

You can try the below steps :

1) Create a common Lookup table for Branch with all the existing branches

2) Create a relationship of this Branch Lookup table with both Quotes and Orders table based on the Branch column/ Branch ID column if it exists as shown below :

3) Then you can pull the Branch column from the Branch lookup into the Matrix grid and Quotes and orders column from their respective tables and can also build a measure for calculation percentage with these 2 columns

Hope this helps!

Please accept the solution if this answers your query.

Thanks,

Avantika Thakur

[MP-iCONN]

Thank you.  This worked perfect!