Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In my current project for business units i am calculating Current year profit and last year profit with growth compare to last year. In my report i am also using filters for months as well. in the report when no filter is applied I am getting the right number for growth but when i am selecting any month from current year i am getting infinity in growth column. Ideally it should calculate the growth. can someone help me with this. I can not share the dashboard as its confidentail. I am sharing scrrenshot of the issue
Solved! Go to Solution.
Hi @ra20067 ,
According to your description, I think your measure has a DIVIDE() function. Please check if the divisor formula returns 0 or blank.
Hi @ra20067 ,
According to your description, I think your measure has a DIVIDE() function. Please check if the divisor formula returns 0 or blank.
Need formula. Sample data wouldn't be the worst thing in the world. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |