Result of Divide is different when count of a column is displayed

[pramita]

Hi all, 
https://docs.google.com/spreadsheets/d/1fFcrdrdrj2hEmO3TARDwYC8fFKzSUvjJgseDGIjv3qI/edit#gid=0

This is my table, I need to to do a simple Divide, between the Antw>4,5 column and MW-f1f2 column. However, when I divide (Conversion = DIVIDE('hotjar'[Antw>4,5],'hotjar'[MW-F1F2]))

both the columns, (New Column = Conversion), I am getting a different result. It is maybe because in the visualization I have taken "Count of MW-F1F2". 

For example, in the 1st row, 3 by 5 should give 0.6, and not 0.01
Kindly let me know where I am going wrong. 

Thanks and Regards
Pramita

[amitchandak]

@pramita , divide should always be measure

Conversion = DIVIDE(sum('hotjar'[Antw>4,5]),sum('hotjar'[MW-F1F2]))

[pramita]

https://docs.google.com/spreadsheets/d/1fFcrdrdrj2hEmO3TARDwYC8fFKzSUvjJgseDGIjv3qI/edit#gid=0

@amitchandak here you go

[pramita]

@amitchandak  I tried that and the answers changed. They are not giving me the right answers nonetheless. 

For example, 1 by 1 is 0.22

[amitchandak]

@pramita Can you share sample data and sample output in table format?

14 % for 6/11 does not seem correct

[pramita]

@amitchandak  I had shared the link to it on my post, please refer to it, I have been trying to log reply for very long, but the post is being marked as spam. 

[Anonymous · Accepted solution]

Hi @pramita ,

I'm little confused about your problem... Do you want to obtain each Mail-Domail the count of [Antw>4,5] divide by the count of [MW-F1F2]? Or obtain each Mail-Domail the summarize value of [Antw>4,5] divide by the summarize value of [MW-F1F2]? I have created a sample file containing these two calculations, you can check the file for details.

If the above info is not what you want, please provide your desired result and the related calculation logic. Thank you.

Best Regards

Rena