Forum Discussion
Helper IIIDynamic column calculate based on slicer date range and filter by two parameters
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
Super User
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
- EZiamslow
d_gosbell wrote:
EZiamslow wrote:I created some process control charts with a slicer on top by date. I need help with calculating average, stdev, and other info based on slicer date range by Step and Product.
This should just be a matter of creating a couple of measures
eg.
Avg Data = AVERAGE( Table1[Data] ) Stdev Data = STDEV.P( Table1[Data] )
(note I've just used "table1" as a placeholder for your table name)
By default these should pull in the current context from any slicers.
That should be easy then. I didn't know slicers will filter out the column calculation for me. I'm over-complicating things. haha.
