Forum Discussion
Calculate and Divide Together
Hi GKs,
As you have mentioned that you are a beginner I have attached a power bi pbix file which you can download from link below.
https://www.dropbox.com/s/zpfk3yfpdevwbul/SalesPercent.pbix?dl=0
in this file I have tested the following result.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Solution SageHi GKs,
As you have mentioned that you are a beginner I have attached a power bi pbix file which you can download from link below.
https://www.dropbox.com/s/zpfk3yfpdevwbul/SalesPercent.pbix?dl=0
in this file I have tested the following result.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
replicate the same formula and only divide the red / red, the other values are infinity
- affan
Anonymous
Have you tried downloading and checking the sample file I have shared?
if I did, however it remains the same with infinity
- MFelix
Super User
Hi Anonymous's
Can you share the measure you are using to calculate the division?
Based on what you are showing it appears to me that you are not placing the ALL statment to get the red even whe you have other groups. You get infinity because you are diving the quantity by null.
Regards,
MFelix
