Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@pramita , divide should always be measure
Conversion = DIVIDE(sum('hotjar'[Antw>4,5]),sum('hotjar'[MW-F1F2]))
@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
@pramita Can you share sample data and sample output in table format?
14 % for 6/11 does not seem correct
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |