Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

NOT IN FILTER DAX

 

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?

Need Help
Show and Tell

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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"))

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

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