calculating differences between rows when using 4 slicers

[roundbunny]

Hi everyone,

I'd like to calculate differences for PRICE when using multiple slicers.   I would like to compare PRICE within the same PRODUCT/STATE/YEAR/SIZE.  (In my dataset, I have one unique row for every combination of PRODUCT/STATE/YEAR/SIZE). 

In the example below, I would want to calculate the difference in price for the blue rows, and do the same thing for the green rows. 

(e.g. the difference for blue rows would be 5-3=2.  The difference for green rows would be 6-5=1.)

I have 4 slicers for PRODUCT, STATE, YEAR, SIZE. 

PRODUCT	STATE	YEAR	SIZE	PRICE
Apple	CA	2001	S	3
Apple	GA	2002	M	4
Apple	CA	2003	S	5
Banana	FI	2002	M	5
Banana	FI	2003	M	6
Banana	FI	2004	M	7
Cherry	CA	2002	L	1
Cherry	FI	2004	M	5

Thank you so much in advance for your help!!! 

[Anonymous · Accepted solution]

Hi @roundbunny ,

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure named ‘Price difference’

Price difference = 
VAR _a = MIN('Table'[PRICE])
VAR _b = MAX('Table'[PRICE])
RETURN _b - _a

2. Fianl output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[roundbunny]

thanks so much!