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])
edhans's avatar
edhans
Community Champion
6 years ago

Can you not just filter them out like this?

VAR __table =
    SUMMARIZE(
        FILTER(
            GeneralStatistics,
            TotalVisits <> 0
        ),
        [Date],
        "__EquipID", [EquipmentIDRatio]
    )
RETURN
    STDEVX.P(
        __table,
        [__EquipID]
    )