Dynamic column calculate based on slicer date range and filter by two parameters

[EZiamslow]

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

[d_gosbell · Accepted 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]

---

@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.