rsbinCommunity Champion6 years agoSolvedStandard 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...Show Moreaz386 years agorsbin try StdDev_EquipID = VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio]) RETURN STDEVX.P(__table,[__EquipID])
az386 years agorsbin try StdDev_EquipID = VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio]) RETURN STDEVX.P(__table,[__EquipID])
az386 years agorsbin try StdDev_EquipID = VAR __table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date],"__EquipID",[EquipmentIDRatio]) RETURN STDEVX.P(__table,[__EquipID])
rsbinCommunity Champion6 years agoedhans 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
edhansCommunity Champion to rsbin6 years agoHey, 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.
Related contentStandard DeviationStandard Deviation DAXStandard Deviation of total salesStandard DeviationStandard Deviation
