Forum Discussion
Solved
Calculate and Divide Together
I am really a beginner with this tool, I am trying to make this calculation with DAX, however it does not show how I would like it. I know something is wrong, I can not find that ...
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
if I did, however it remains the same with infinity
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
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