Calculate price difference for each row in tableau

Question

I want to create a report with the following data

Item | Price | Difference

A | 1.00 | 0

B | 2.00 | 1.00

C | 0.50 | -0.50

How can I get output in this way

A | 1.00 | -1.00

B | 2.00 | 0.00

C | 0.50 | -1.50 

Answer 1

Check with the following calculated feilds

"Get parameter select price" = IF [F1 Parameter] = [F1] THEN [Price] END

"Parameter Selected Value for all rows" = {FIXED: MAX(IF [F1 Parameter] = [F1] THEN [Price] END)} 

"Difference" = [Price] - [Parameter Selected Value for all rows] 

Want to be an expert, check the tableau certification course