Calculate DAX for a Context

Question

Hi,&nbsp;Below is a table where PERIOD_1 &amp; PERIO_2 are selected by the user, hence these are from the original table columns, the section "CHANGE" is dynamic calculation performed per user selection on P1 &amp; P2. I am able to calculate the COST_DELTA, but need help in creating a DAX measure for MIN_COST_DELTA for each SKU, and this value should remain Static irrespective to users selection of LOCATION using filters.&nbsp;&nbsp;&nbsp;PERIOD 1PERIOD 2CHANGESKULOCATIONCOSTCOSTCOST_DELTAMIN_DELTA_COSTABC_123A1&nbsp;$&nbsp;&nbsp;&nbsp; 1.100&nbsp;$&nbsp;&nbsp;&nbsp; 1.500&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.400&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)ABC_123A2&nbsp;$&nbsp;&nbsp;&nbsp; 1.150&nbsp;$&nbsp;&nbsp;&nbsp; 1.200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.050&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)ABC_123A3&nbsp;$&nbsp;&nbsp;&nbsp; 1.450&nbsp;$&nbsp;&nbsp;&nbsp; 1.600&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.150&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)ABC_123A4&nbsp;$&nbsp;&nbsp;&nbsp; 1.200&nbsp;$&nbsp;&nbsp;&nbsp; 1.050&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)ABC_123A5&nbsp;$&nbsp;&nbsp;&nbsp; 1.000&nbsp;$&nbsp;&nbsp;&nbsp; 1.200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.150)DEF_234B1&nbsp;$&nbsp;&nbsp;&nbsp; 2.400&nbsp;$&nbsp;&nbsp;&nbsp; 2.200&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.200)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)DEF_234B3&nbsp;$&nbsp;&nbsp;&nbsp; 3.000&nbsp;$&nbsp;&nbsp;&nbsp; 2.600&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)DEF_234B6&nbsp;$&nbsp;&nbsp;&nbsp; 2.800&nbsp;$&nbsp;&nbsp;&nbsp; 2.400&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)DEF_234B8&nbsp;$&nbsp;&nbsp;&nbsp; 1.900&nbsp;$&nbsp;&nbsp;&nbsp; 2.700&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.800&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.400)&nbsp;

sevenhills · Accepted Answer

You can try this also:To calculate difference in cost (measure)
Diff Cost = sum('Table'[Period 2 COST]) - Sum('Table'[Period 1 COST])
To calculate minimum of difference in cost in each SKU (measure):
Min Diff Cost by SKU = 
Minx ( FILTER( all ('Table'), 'Table'[SKU] = SELECTEDVALUE('Table'[SKU]))
       , [Diff Cost])
&nbsp;Output:

&nbsp;

&nbsp;
&nbsp;

		PERIOD 1	PERIOD 2	CHANGE
SKU	LOCATION	COST	COST	COST_DELTA	MIN_DELTA_COST
ABC_123	A1	$ 1.100	$ 1.500	$ 0.400	$ (0.150)
ABC_123	A2	$ 1.150	$ 1.200	$ 0.050	$ (0.150)
ABC_123	A3	$ 1.450	$ 1.600	$ 0.150	$ (0.150)
ABC_123	A4	$ 1.200	$ 1.050	$ (0.150)	$ (0.150)
ABC_123	A5	$ 1.000	$ 1.200	$ 0.200	$ (0.150)
DEF_234	B1	$ 2.400	$ 2.200	$ (0.200)	$ (0.400)
DEF_234	B3	$ 3.000	$ 2.600	$ (0.400)	$ (0.400)
DEF_234	B6	$ 2.800	$ 2.400	$ (0.400)	$ (0.400)
DEF_234	B8	$ 1.900	$ 2.700	$ 0.800	$ (0.400)

Forum Discussion

Calculate DAX for a Context

2 Replies

Related content

Context Transition in DAX

DAX for calculating retroactive values

DAX Calculated Measure

DAX Calculation

DAX Calculate context - creating own YTD