Filter on a Matrix, but keeping related value not matching the filter

[mfgAnalytics]

Hello everyone,

i am tackeling a challenge in visualization that is not easy for me as a beginner to solve. I need the following visualization as a matrix:

(As it is a matrix the empty cells below each item in SalesItem and Price are not in the actual visualization)

SalesItem	Price	SalesStore	OnStock
USB-Charger	19,99 EUR	Downtown	5
		ShoppingCenter	3
		Rural Area	1
Laptop 5GHz	999,99 EUR	Downtown	2
		Rural Area	2
Gaming PC	1299,49 EUR	Shopping Center	1
GPU 4090 Super	2299,00 EUR	Downtown	6
		Rural Area	1

Now the challenge:

I want to filter by >Location< but keep all lines of other locations that have listed the same item.

Example #1:

Slicer for SalesStore: Downtown

Result:

SalesItem	Price	SalesStore	OnStock
USB-Charger	19,99 EUR	Downtown	5
		ShoppingCenter	3
		Rural Area	1
Laptop 5GHz	999,99 EUR	Downtown	2
		Rural Area	2
GPU 4090 Super	2299,00 EUR	Downtown	6
		Rural Area	1

Example #2:

Slicer for SalesStore: ShoppingCenter

Result:

SalesItem	Price	SalesStore	OnStock
USB-Charger	19,99 EUR	Downtown	5
		ShoppingCenter	3
		Rural Area	1
Gaming PC	1299,49 EUR	Shopping Center	1

The data model:

Table A: SalesItem, Price

Table B: SalesItem, SalesStore, Quantity

Key: SalesItem

Is it possible to solve this challenge in PowerBI?

[danextian]

Hi @mfgAnalytics ,

Please provide a sample data (or better yet a sample pbix) and not just the expected result

Question:
but keep all lines of other locations that have listed the same item. You mean that if a location (is that the store name?) is selected and a store has that item, all lines from all other locations that has that item is to be shown as well? Can you please explain your sample result?

[mfgAnalytics]

Question:
"but keep all lines of other locations that have listed the same item."
You mean that if a location (is that the store name?) is selected and a store has that item, all lines from all other locations that has that item is to be shown as well? Can you please explain your sample result?

Yes, this is correct. If I for example select Downtown as a location, only the Gaming PC Line would disappear from the visualization, and all SalesItems with all their locations would remain in the visualization, because they are also sold at Downtown location.

I have a pbix ready, but dont know where to upload. It's not working here as pbix or zip.

[danextian]

Only superusers can attach files but you can always save sample file in a cloud storage (onedrive, gdrive, dropbox) and paste the  publicly accessible link to it.