Forum Discussion
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 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 |
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
