Forum Discussion
Can't calculate conversion rate properly
It looks like the issue might be with the 'First payment date' calculation. The 'First payment date' measure is using a variable to calculate the minimum payment date for each order in the 'Orders' table, but it's not clear how the 'Payments' table is related to the 'Orders' table.
To calculate the 'First payment date' measure correctly, you need to make sure that there is a relationship between the 'Orders' table and the 'Payments' table based on the order ID column. Once you have established the relationship, you can use the RELATED function to retrieve the payment date from the 'Payments' table. Here's an updated measure that should work:
First payment date = CALCULATE( MIN('Payments'[PaymentDate]), USERELATIONSHIP('Orders'[Order ID], 'Payments'[Order ID]) )Once you have corrected the 'First payment date' measure, you should be able to calculate the conversion rate correctly using the measures you have defined.
Solution Sage
It looks like the issue might be with the 'First payment date' calculation. The 'First payment date' measure is using a variable to calculate the minimum payment date for each order in the 'Orders' table, but it's not clear how the 'Payments' table is related to the 'Orders' table.
To calculate the 'First payment date' measure correctly, you need to make sure that there is a relationship between the 'Orders' table and the 'Payments' table based on the order ID column. Once you have established the relationship, you can use the RELATED function to retrieve the payment date from the 'Payments' table. Here's an updated measure that should work:
Once you have corrected the 'First payment date' measure, you should be able to calculate the conversion rate correctly using the measures you have defined.
Thank you so much! It worked
