Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
5 years ago

Filter a Measure Value

Hello All, 1. I have created a table for Measure Names to use a Filter,(CycleTime1,CycleTime2) 2.Created Two Columns  CycleTime1 = Datediff(Time2,Time1,Sec), CycleTime2 = Datediff(Time3,Time2,Sec) ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

harshagraj , change these measures like and check

Average = CALCULATE(AVERAGEX(CTM_Timestamps, IF(
HASONEVALUE('MeasureTable'[Measures]),
SWITCH(
VALUES('MeasureTable'[Measures]),
"CycleTime1 ,AVERAGE(CTM_Timestamps[CycleTime1]),
"CycleTime2 ,AVERAGE(CTM_Timestamps[CycleTime2]),
AVERAGE(CTM_Timestamps[CycleTime1])
))),ALLSELECTED(CTM_Timestamps))

 


STDEV = CALCULATE(STDEVX.P(CTM_Timestamps, IF(
HASONEVALUE('MeasureTable'[Measures]),
SWITCH(
VALUES('MeasureTable'[Measures]),
"CycleTime1 ,AVERAGE(CTM_Timestamps[CycleTime1]),
"CycleTime2 ,AVERAGE(CTM_Timestamps[CycleTime2]),
AVERAGE(CTM_Timestamps[CycleTime1])
))),ALLSELECTED(CTM_Timestamps))

harshagraj's avatar
harshagraj
Post Partisan
5 years ago

Hello Amit unfortunately I am getting NAN errors if i do that 😞