Change filter value

Hi Oleg222 

Is there anything wrong in your  sample? If you want to get result as above, I think there should be Product1 to 3 instead of only Product1 in your sample data in warehouse2.

I  think your sample data should looks as below.

Build an unrelated warehouses table for slicer.

Warehourse = VALUES('Table'[Warehouses])

Measures:

Expense = 
IF(ISFILTERED(Warehourse[Warehouses]),CALCULATE(SUM('Table'[Value (expense)]),FILTER('Table','Table'[Warehouses] = SELECTEDVALUE(Warehourse[Warehouses]))),BLANK())

Income = 
IF(ISFILTERED(Warehourse[Warehouses]),CALCULATE(SUM('Table'[Value (expense)]),FILTER('Table','Table'[Warehouses] <> SELECTEDVALUE(Warehourse[Warehouses]))),BLANK())

Build a Matrix and use Show on rows in value in your matrix format.

Best Regards,
Rico Zhou

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