Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ra20067
Helper I
Helper I

Error with measure

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 issueissue.JPG

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @ra20067 ,

 

According to your description, I think your measure has a DIVIDE() function. Please check if the divisor formula returns 0 or blank.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
v-eachen-msft
Community Support
Community Support

Hi @ra20067 ,

 

According to your description, I think your measure has a DIVIDE() function. Please check if the divisor formula returns 0 or blank.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.