Help! Filter doesn't work on measure

Question

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(&nbsp; &nbsp; &nbsp; SUM(FactProduction[Data]),&nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; FactProduction,&nbsp; &nbsp; &nbsp; FactProduction[Assay] = EARLIER( FactProduction[Assay]) &amp;&amp;&nbsp; &nbsp; &nbsp; FactProduction[Date] = EARLIER( FactProduction[Date] )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))YTD =&nbsp; &nbsp; &nbsp; &nbsp;CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM ( FactProduction[Sum per day]) / COUNTA(FactProduction[Data]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT(FactProduction, FactProduction[Assay]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FactProduction[Date] &lt;= SELECTEDVALUE(FactProduction[Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; )The filters (Context) works with the calculated column (Sum per day), but not works with the measure (YTD)&nbsp;Thanks :)

v-juanli-msft · Accepted Answer

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.&nbsp;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?&nbsp;Best regards,Maggie Li

Forum Discussion

Help! Filter doesn't work on measure

1 Reply

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER