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
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.