Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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: ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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
)

     

     

MFelix's avatar
MFelix
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the help !!!

     

    It resolved my issue.

     

    Regards,

    Himanshu