Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 2
Measure 1 is OK and working
Measure 1: vMax_Year_PY = Max('SALES'[Year])-1
Note: Year is a separate field in the Sales table
I want to treat vMax_Year_PY almost as a “global variable” in different measure functions…
Measure 2: CALCULATE(SUM('Sales'[Sales]),'Sales'[Year] = vMax_Year_PY )
Is there any syntax to make this type of function work??
Try this one
Measure 2 = VAR MyYear = [vMax_Year_PY] RETURN CALCULATE ( SUM ( 'Sales'[Sales] ), FILTER ( ALLSELECTED ( Sales[YEAR] ), 'Sales'[Year] = MyYear ) )
Hi Zubair
I 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 ) )
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.
Please see the image and Sandbox App in the link: https://drive.google.com/drive/folders/1ZPtPMgDm1CID4AnezDGsu49ve1vY0EtP?usp=sharing
https://drive.google.com/drive/folders/1ZPtPMgDm1CID4AnezDGsu49ve1vY0EtP?usp=sharing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |