Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

conversion ratio

Hello to all of you!   I got 1 table with my quotes and 1 table with my orders. I would like to have my conversion rate (how many quotes I converte into an order).   Quotes Date            Docum...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Try this...Add a new Column to your Orders Table "Quote Date".....using RELATED or LOOKUPVALUE function in DAX....

 

Then you can use this MEASURE to get the conversion ratio

 

Conversion Ratio =
DIVIDE (
    CALCULATE (
        COUNT ( Orders[Quote N°] ),
        FILTER (
            ALL ( Orders ),
            Orders[Quote N°] <> "None"
                && MONTH ( Orders[Quote Date] ) = MONTH ( Orders[Date  ] )
                && YEAR ( Orders[Quote Date] ) = YEAR ( Orders[Date  ] )
        )
    ),
    CALCULATE ( COUNT ( Orders[Document N°] ), Orders[Quote N°] <> "None" )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I got a Date Table linked with the tables. Maybe it will be easier?