Referencing one DAX measure in another

Question

I know there are other ways of doing this, but I want to know if there is a way to do the following:I want to reference Measure 1 in Measure 2Measure 1 is OK and working&nbsp;&nbsp;Measure 1:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vMax_Year_PY &nbsp;= Max('SALES'[Year])-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Note: &nbsp;&nbsp;&nbsp; Year is a separate field in the Sales table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I want to treat vMax_Year_PY &nbsp;almost as a “global variable” in different measure functions…&nbsp;Measure 2:&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(SUM('Sales'[Sales]),'Sales'[Year] = vMax_Year_PY )Is there any syntax to make this type of function work??

zubair_muhammad · Answer

navpienaar&nbsp;Try this one&nbsp;Measure 2 =
VAR MyYear = [vMax_Year_PY]
RETURN
    CALCULATE (
        SUM ( 'Sales'[Sales] ),
        FILTER ( ALLSELECTED ( Sales[YEAR] ), 'Sales'[Year] = MyYear )
    )

navpienaar · Answer

Hi ZubairI am getting part of the correct answer with the following if I select a specific Year:Sales PY = VAR MyYear = [vMax_Year_PY] RETURN CALCULATE ( SUM ( TRANS[Sales] ), FILTER ( ALL ( TRANS[YEAR] ), TRANS[YEAR] = MyYear ) )&nbsp;However, it does not give me all the Sales for the Previous Year (all products), if in the there were no sales for specific products in the selected year.&nbsp;Please see the image and Sandbox App in the link:&nbsp;https://drive.google.com/drive/folders/1ZPtPMgDm1CID4AnezDGsu49ve1vY0EtP?usp=sharinghttps://drive.google.com/drive/folders/1ZPtPMgDm1CID4AnezDGsu49ve1vY0EtP?usp=sharing&nbsp;&nbsp;

Forum Discussion

Referencing one DAX measure in another

2 Replies

Related content

Field parameter selecting measures, referenced in another measure?

Query referencing another query

Referencing a SUMX measure in another measure

Referencing one Table with Another

SUMX Measure referencing another Measure