I am in the middle of writing a DAX that should pick one line item according to the filters and subtract the sum of that value from another column, and this should be done for each of the columns for example I have below:
COL A COL B COL C COL D COL E
IMA FleetA 2.5 1.2 44
IMA FleetB 2.5 1.4 23
IMA FleetC 2.5 1.1 21
Now I want to subtract COL B value of COL C (After adding COL C and COL D for COL B) and then subtract from COL E for each of the items respectively for COL B. How can I write a DAX that should take care of this process and rather not me writing each of the DAX formula by filtering out each unit?