Measure

[Anonymous]

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:

Average Weighted Term Length (MWh) = CALCULATE(SUM(View_DealClosing[Weighted Calc])/SUM(View_DealClosing[Term Usage (MWh)]))

Regards,

Himanshu

Idealy 0/0 should be 0 but dont understand what is this NaN.

[MFelix · Accepted solution]

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
)

[Anonymous]

Thanks for the help !!!

It resolved my issue.

Regards,

Himanshu