Forum Discussion

Oleg222's avatar
Oleg222
Helper II
4 years ago
Solved

Change filter value

Hi. An example of a situation - there are 2 warehouses and the table contains information only about the expense of products from one warehouse to another (for example, from warehouse 2 to warehouse ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.