Hey Sam,

Since the “original” distribution table is on a fixed axis and will not change when I click on any natural filters I have on the page, I want to do as you said from previous posts and layer different distribution curves on the same chart to provide a different comparison.

For example:

My the table that I first generated was distribution data over the past thirty years of my business. That is based on the formulas from the previous posts. Now I want to compare 2018 data and view that distribution curve and compare to over thirty years.

The problem is that I need to make this formula dynamic so that I can overlay based on choosing different filters

Current Formula `f(x) = NORM.DIST('Normal Distribution'[X],[Mean (μ)],[Stand Dev. (σ)],0)`

Proposed Formula `f(x) Filtered = NORM.DIST('Normal Distribution Filtered'[X Filtered],[Mean (μ) (filtered)],[Stand Dev. (σ) (filtered)],0)"`

where

```
Mean (μ) (filtered) = CALCULATE(average(Customer_AR_Tbl_Reciept_Date[Gross Profit - USD]),Date_Tbl[Year]=2018)
Stand Dev. (σ) (filtered) = CALCULATE(STDEV.S(Customer_AR_Tbl_Reciept_Date[Gross Profit - USD]),Date_Tbl[Year]=2018)
X - 3σ (filtered) = CALCULATE([Mean (μ) (filtered)]-3*[Stand Dev. (σ) (filtered)],Date_Tbl[Year]=2018)
X + 3σ (filtered) = CALCULATE([Mean (μ) (filtered)]+3*[Stand Dev. (σ) (filtered)],Date_Tbl[Year]=2018)
```

However,

I can not get away from having to generate another table to calculate a curve based on the selected filters, i.e. Year, State, City, etc…

I need to somehow create a virtual table so that the formulas can update based on the selected filters. I know I am close, but I am not seeing it. What are your thoughts.