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, friends!
Please, help me in my issue: I want to calculate the percent of fee in our company, but after calculation, I see only Infinity or Nan.
Could you please, clarify the reasons for this problem?
Thank you in advance!
Solved! Go to Solution.
Thanks for sharing your pbix. I think I've found the reason. It is a calculated column in your case, and the field dz or grs both can be 0, so you always get 0 or infinity. In you case, instead of calculated column, create a measure instead.
Measure = DIVIDE(sum(t3[dz]),sum(t3[grs]))
Are you not using the DIVIDE() function?
Proud to be a Super User!
Hi!
When I use this function, I see only "0" in results.
Yes, of course!
I use function DIVIDE([dz];[grs])*100 , when dz (debt sum) and grs(grossrev) are integer datas.
I've added a few screenshots for better understanding.
After this process I see 0 as a result.
OK. Could you try to convert the measure type to "decimal number" and change the precision(3 in below snapshot) accordingly?
Still, doesn't work.
Thanks for sharing your pbix. I think I've found the reason. It is a calculated column in your case, and the field dz or grs both can be 0, so you always get 0 or infinity. In you case, instead of calculated column, create a measure instead.
Measure = DIVIDE(sum(t3[dz]),sum(t3[grs]))
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |