Forum Discussion

jinsbi's avatar
jinsbi
New Member
4 years ago
Solved

Filter out NaN values in column

Hi All,

I have a column called "Value" in my PBI file,  which is of Decimal Number type by default also containing "NaN".  "NaN" came directly from the source file.  So it causes my DAX function to display NaN. Is there any way to avoid it? ( Without replacing NaN to 0). 

my DAX is 

Energy export = CALCULATE(sum(Turbine_Data[Value]),FILTER(Turbine_Data,Turbine_Data[Signal]="Energy Export (kWh)"))

 

 

 

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi jinsbi 

    I think you need to remove NaN at row level to avoid erros in your calculation. Try:

    Energy export =
CALCULATE (
    SUMX ( Turbine_Data, IF ( Turbine_Data[Value] > 0, Turbine_Data[Value] ) ),
    Turbine_Data[Signal] = "Energy Export (kWh)"
)

    Please let me know if solved your problem. If so, kindly mark my reply as accepted solution. Thank you!