Help! Filter doesn't work on measure

[GeorgiBarov]

Hello,

I'm trying to get the Average YTD per Context and Assay, but the formula that I'm using calculate the whole sum.

For example in YTD (which is measure) I want to recieve Cu per context(Actual/ Budget/etc..)

To get the result I create calculated column(Sum per day) and measure (YTD)

Sum per day =
CALCULATE(
      SUM(FactProduction[Data]),
      FILTER(
      FactProduction,
      FactProduction[Assay] = EARLIER( FactProduction[Assay]) &&
      FactProduction[Date] = EARLIER( FactProduction[Date] )
          )
)

YTD =
       CALCULATE (
            SUM ( FactProduction[Sum per day]) / COUNTA(FactProduction[Data]),
            FILTER (
            ALLEXCEPT(FactProduction, FactProduction[Assay]),
                FactProduction[Date] <= SELECTEDVALUE(FactProduction[Date])
            )
      )

The filters (Context) works with the calculated column (Sum per day), but not works with the measure (YTD)

 Thanks 🙂

[v-juanli-msft · Accepted solution]

Hi GeorgiBarov,

Based on the data model displayed, I make a test on my site and it turns out the result below. In calculated column (Sum per day) it can’t receive Cu per context.

 

Can I confirm with you whether there is any other information when created the calculated column, additionally, to help you effectively, would you please give a picture showing a list of result you want in YTD column?

Best regards,
Maggie Li