Change filter value

[Oleg222]

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 1). Need a measure for the arrival from another warehouse. It is necessary to insert the same measure for expense but forcibly change the name of the warehouse in it (put the name of the recipient). In the matrix, when choosing a warehouse in the section, there were 2 measures - an expense and an income.

Warehouses    Product       Value (expense)

warehouse1	product1	100
warehouse1	product2	110
warehouse1	product3	120
warehouse2	product1	200
warehouse2	product1	210
warehouse2	product1	220

Necessary result (Slicer by warehouse1):

Type          product1    product2     product3

expense	100	110	120
income	200	210	220

[Oleg222]

@Pragati11,  changed description.

[v-rzhou-msft · Accepted solution]

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.

[Pragati11]

HI @Oleg222 ,

Can't understand your question properly. Please go through the following article to make sure you provide all the relevant information for your query above:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati