Forum Discussion

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity 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
Icon for Community Champion rankCommunity 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]
    )
  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion
    6 years ago

    edhans   Thanks kindly for the reply.  Same solution as az38     ....he just beat you to it.

     

    Appreciate you chiming in and confirming solution.

     

    All the Best

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hey, no problem rsbin - he was quicker with the enter key!

       

      Kudos/Thumbs up are still welcome. In any event, glad your problem is resolved and your project is moving forward.