Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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. Is it possible to calculate for what I need? What would be the best option?
Date_Time | ID | Step | Data | Product |
10/13/18 7:11 PM | 128396 | DEF | 7.46 | MMM |
10/14/18 8:08 PM | 128346 | ABC | 9.634 | YYY |
10/14/18 9:47 PM | 128350 | ABC | 9.565 | YYY |
10/14/18 10:02 PM | 128348 | ABC | 9.617 | YYY |
10/14/18 10:42 PM | 128373 | ABC | 9.682 | YYY |
12/13/18 8:00 PM | 128351 | ABC | 9.77 | YYY |
12/13/18 11:13 PM | 128349 | ABC | 9.772 | YYY |
12/13/18 11:24 PM | 128314 | ABC | 9.759 | YYY |
12/14/18 4:35 PM | 128308 | ABC | 9.736 | YYY |
12/16/18 10:21 AM | 128351 | DEF | 7.466 | YYY |
12/16/18 1:29 PM | 128314 | DEF | 7.442 | MMM |
12/16/18 1:37 PM | 128349 | DEF | 7.431 | MMM |
12/22/18 3:43 PM | 128292 | DEF | 7.426 | MMM |
12/22/18 4:02 PM | 128348 | DEF | 7.435 | MMM |
12/22/18 4:47 PM | 128373 | DEF | 7.403 | MMM |
12/23/18 4:52 PM | 128350 | DEF | 7.406 | MMM |
12/23/18 5:01 PM | 128390 | DEF | 7.444 | MMM |
12/23/18 8:38 PM | 128394 | DEF | 7.433 | MMM |
12/26/18 1:18 PM | 128354 | DEF | 7.481 | YYY |
12/26/18 1:25 PM | 128308 | DEF | 7.438 | MMM |
12/26/18 1:30 PM | 128325 | DEF | 7.447 | MMM |
12/26/18 1:35 PM | 128817 | DEF | 7.524 | YYY |
Solved! Go to Solution.
@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 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.
@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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |