I have a growth calulated measure but the values are coming as nan and Infinity
below is the sample data
The dax to calulate is
Go to Solution.
You are getting NAN and Infinity because you are dividing 0 by 0 and 747 by blank ( where blanks it considers as zero)..
You will have to change your formula.
or you can try creating 2 quick measures.
- 1st measure for subtraction SUM and Gross Revenue
- 2nd to divide the above measure with Gross Revenue.
Add in table to get somehting like this.
Let me know if this helps .
use the DIVIDE function instead of "/"
It worked with the Divide. Thanks
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.