Create a measure with aggregated values considering existing filters

Question

Dear Community,&nbsp;I have a project table containing many projects and values per month. I would like to create a measure that accumulates all values p to a certain date but considering existing filters, such as for example only for "Project A" if this is chosen in the visual filters.&nbsp;ProjectFinancials TableProjectIDValuePeriod YMPropertyABCProject A10202201eProject A20202202fProject A30202203gProject A25202204gProject A48202205fProject A15202206eProject B84202201rProject B85202202rProject B29202203rProject B67202204zProject B28202205zProject B44202206s&nbsp;Now I have created a measure like this, however this one does not consider any filters (since I chose "ALL").&nbsp;PlannedAcc = VAR EndDate = SELECTEDVALUE(DateTable[Period YM]) // this is a value YYYYMMRETURN SUMX( CALCULATETABLE(   'FACT-Project Financials',    ALL('FACT-Project Financials'),   'FACT-Project Financials'[Period YM] &lt;= EndDate ), 'FACT-Project Financials'[Value] )I plan to use a clustered column chart with the months on the x-axis and the cumulated values per month. Any filter applied to the chart, such as project ID or some other property needs to take effect on the cumulated values.&nbsp;Can anyone help?&nbsp;Thanks in advanceH.

mwegener · Accepted Answer

Hi&nbsp;TheHans&nbsp;,
&nbsp;
try this.
PlannedAcc =

VAR EndDate = MAX(DateTable[Period YM]) // this is a value YYYYMM

RETURN

CALCULATE(
    SUM('FACT-Project Financials'[Value]),
    FILTER(ALL(DateTable), DateTable[Period YM] &lt;= EndDate)
)

Forum Discussion

Related content

Data Aggregation issue

Bottom 10 considering repeated value.

Aggregate

Dax measure not considering the filter context and not aggregating

Non-aggregated matrix?