Measure to filter avaliable data in the slicer

[Natalia10000]

Hi, I have a following problem, I want to have two slicers: one with Country (from Warehouse table) and another one with Article (from Article table), but in the Article slicer I want to select only artciles that are available in the country selected in the first slicer, would you be able to help me with this? The relationships are as below:

[Natalia10000]

thank you, but I think there is still sth wrong, I used the following measure

Measure =
VAR val_war =
VALUES ( Warehouse[Country No] )
VAR val_art =
SELECTEDVALUE ( Article[Country No] )
VAR result =
IF ( val_art IN val_war, 1 )
RETURN
result

and it doesn't work

[blopez11]

Create the following measure (from the sqlbi blog post), change the name and replace the table in ISEMPTY with whatever table that is in the middle of the picture you shared, then add this measure as a visual level filter on article slicer with condition "is 1".

Slicer_ProductsWithSales = INT ( NOT ISEMPTY ( Sales ) )

[blopez11]

You can use the same concept as in the article below, but use that table in the middle in the DAX (I can't tell it's name from the screenshot).

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

[Natalia10000]

Hi, thank you for your help, unfortunately it did not solve my problem, but I found another one with summarize function.