NOT IN FILTER DAX

[Anonymous]

Hello,

I have to tables; goods and Sales. There is a one-to-many relationship between tables. The thing I want to do: When I filter goods using a slicer I want to get customer codes of where A does not exist in my report. Can anyone help me out how to find a solution for this porblem?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

This is  excellent. Thank you very much @ashish

[Ashish_Mathur]

You are welcome.

[ryan_mayu]

@Anonymous 

not clear about your question. What do you mean A does not exist in your report? Could you pls provide the expected output?

[amitchandak]

@Anonymous , if you want to select A and want to exclude it from the report, then better use an independent slicer

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

If just exclude a

create measure 

= calculate(countrows(sales), filter(good, good[goods]<> "A"))