Calculate difference between values of a column from a particular value of same column

[Anonymous]

 Hello,

 I am trying to calculate the difference between values of a column from a particular value of same column. I want to create a DAX field - "Diff of Bill from F" that calculate the difference in bill from the bill of  Company F. I also have a rank column based on the bill amount but I am not sure if that could be used to calculate this.

I am currently stuck on this, I've found similar questions but I couldn't apply them to my problem as most of them are calculating consecutive differences. 

Year	Month	Company	Bill	Diff of Bill from F
2020	June	A	954	-181
2020	June	B	949	-176
2020	June	C	908	-135
2020	June	D	811	-38
2020	June	E	809	-36
2020	June	F	773	0
2020	June	G	754	19

Any help would be greatly appreciated.

Thank you.

[lbendlin]

here's the pseudo code for the measure. Adjust as needed. Basically eliminate the company from the filter context to find the F value.

Diff =

var f = calculate (sum (bill), filter(allexcept(table,company),company="F"))

return sum(bill)-f

[Anonymous · Accepted solution]

Thank you. I was able to solve by doing a slight change in the DAX. Using below DAX I was able to get the desired result.

Diff = var f = CALCULATE([Annual Bill],FILTER(ALL(Table[Company]),Table[Company]="F")) return [Annual Bill] - f