Forum Discussion

rsbin's avatar
rsbin
Community Champion
6 years ago
Solved

Standard Deviation yields NaN error

Good Afternoon All & Greg_Deckler    Following up on my previous thread wherein I used the following formula to calculate Standard Deviation:   StdDev_EquipID = VAR __table = SUMMARIZE(GeneralSt...
Need Help
  • az38's avatar
    az38
    6 years ago

    rsbin 

    try

    StdDev_EquipID =
VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio])
RETURN STDEVX.P(__table,[__EquipID])
az38's avatar
az38
Community Champion
6 years ago

rsbin 

try

StdDev_EquipID =
VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio])
RETURN STDEVX.P(__table,[__EquipID])
rsbin's avatar
rsbin
Community Champion
6 years ago

Thank you az38 !!   Appreciate the fast response.  I knew I needed a filter in there somewhere, just couldn't get the syntax right.

 

Thanks again and All the Best.