Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average by volume range

Hi Everyone,   I have a fact table with location Ids and turnaround times, and measures that calculates the average turnaround time as well as counts the work order quantity. I have another table t...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ，

    Please try to create the below 2 measures:

    TatAvgStdDevFiltererd = 
 var selectedValue = MIN('SelectedVolumn'[30DayVolume])
var ds  = [30DayStdev]
return
AVERAGEX(FILTER(all('StDevModel'),'StDevModel'[30DayVolume]>selectedValue&&'StDevModel'[30DayVolume]<selectedValue+ds),[AvgTat])
    WoQtyAvgStdDevFiltererd = 
 var selectedValue = MIN('SelectedVolumn'[30DayVolume])
var ds  = [30DayStdev]
return
AVERAGEX(FILTER(all('StDevModel'),'StDevModel'[30DayVolume]>selectedValue&&'StDevModel'[30DayVolume]<selectedValue+ds),[WoQty])

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi there,

 

Would anyone have come up to a solution for this?

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ，

Please try to create the below 2 measures:

TatAvgStdDevFiltererd = 
 var selectedValue = MIN('SelectedVolumn'[30DayVolume])
var ds  = [30DayStdev]
return
AVERAGEX(FILTER(all('StDevModel'),'StDevModel'[30DayVolume]>selectedValue&&'StDevModel'[30DayVolume]<selectedValue+ds),[AvgTat])
WoQtyAvgStdDevFiltererd = 
 var selectedValue = MIN('SelectedVolumn'[30DayVolume])
var ds  = [30DayStdev]
return
AVERAGEX(FILTER(all('StDevModel'),'StDevModel'[30DayVolume]>selectedValue&&'StDevModel'[30DayVolume]<selectedValue+ds),[WoQty])

Best Regards

Rena