No workbook attached here.
I think you should create below calcualted field for conversion%
SUM([Orders (Example)].[Count Of Orders]) / SUM([Count of installs])
I will bring platfrom to color mark for Second question.
Third question - I always prefer join compare to data blending. I think, Joins give me more option than blending. If your requirements are only this. you can use blending or join.
Attaching workbook as well.
Conversion.twbx 59.7 KB
I think this should work for some of the simpler use cases.
I'm facing a problem when trying to slice calculate by different dimensions.
A follow up question based on what you said - How can I do this if I did a JOIN at the SQL level?
The data would be on a user level basis, see example below.
How would I replicate the excel COUNTIF? (please do let me know if there is a better way)
thank you & happy Diwali!