How to filter

[Erik_Andersen]

Hi all

I need help. I'm trying to make a filter where I can see which costumers that have bought different goods in a specific periode.

In the below I have filtered on a costumer that have bought "Kaffe", "Kakao", "Tilbehør", "Rengøring". "Emballage" but not "Te", "Sirup", "Brugsartikler" og "Isenkram".

When I filter on the periode (year 2023) the costumer should disappear from the tabel because the "kakao" was bought in 2022.

Is there anyone that can help me solve the problem? The data comes from different tabels.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...