Forum Discussion
Measure
Hi Guys,
Please refer the below screenshot.
I've created a measure for my model and don't understand what these NaN is coming in my visual.
Can anybody suggest me what is this.
Measure:
Regards,
Himanshu
Idealy 0/0 should be 0 but dont understand what is this NaN.
Hi Anonymous ,
The NaN error occurs when you are dividing 0 by 0, in your case you can use a divide funciton with the additional parameter to your divide function to return whatever value you want in this case maybe 0 so redo your measure to:
Average Weighted Term Length (MWh) = DIVIDE ( SUM ( View_DealClosing[Weighted Calc] ), SUM ( View_DealClosing[Term Usage (MWh)] ), 0 )
2 Replies
Hi Anonymous ,
The NaN error occurs when you are dividing 0 by 0, in your case you can use a divide funciton with the additional parameter to your divide function to return whatever value you want in this case maybe 0 so redo your measure to:
Average Weighted Term Length (MWh) = DIVIDE ( SUM ( View_DealClosing[Weighted Calc] ), SUM ( View_DealClosing[Term Usage (MWh)] ), 0 )