Conversion% calculation

[Anonymous]

Hi Everyone,

Can any help me, How to divide two measures from two different tables to find the Conversion%.

I have two tables which contains both fact and dims(No sepearate tables tables for dim & fact). I have created one measure in Table A to find amount of Table A & Created one more measure in Table B to find amount.

I have requirement to divide the table B measure with Table A measure and I have to show that divide% in matrix visual along with Table A measure.

ex: 2017-Q1 of measure(Table B) should divide with 2017-Q1 of measure(Table B) similar to all.

Used date in column level, region row level, Measure(table A) in values.

req:I have to use the divide% in matrix.

Thanks& Regards,

[Anonymous]

Hi @Anonymous ,

You should be able to directly divide measureA with measureB by creating below measure.

_div = [measureA]/[measureB]

Then if you want to put columns in tableA and tableB into a single visual, you will need to create a relationship between them.

If I misunderstand your meaning, please show some sample data and expected result.

Best Regards,

Jay

[amitchandak]

@Anonymous , You should be able to divide measures from Table A and Table B. And display them across common dimensions and grand total. You need have date table to join with date of each table 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.