Error with measure

[ra20067]

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

[v-eachen-msft · Accepted 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.

[Greg_Deckler]

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