Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter multiple Rows with same value (in column 1) when a value (in column 2) is given

Dear all, I need your support in writing a DAX formula. Situation I have a table that contains a column "Auftragsnummer" (order no.) and a column "Artikel" (article). There can be several article...
  • ribisht17's avatar
    ribisht17
    4 years ago

    Anonymous 

     

    For example we don't want any row with product A/ignore all the orders if it has A

    Solution = IF( ISBLANK( CALCULATE(max('Ignore'[Column2]),(ALLEXCEPT('Ignore','Ignore'[Order No.])),'Ignore'[Column2]="A")),1,0)

    Now you can filter 1 to get the desired output

     

     

    Thanks,
    Ritesh
    Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
    My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

     

ribisht17's avatar
ribisht17
Super User
4 years ago

Anonymous 

 

For example we don't want any row with product A/ignore all the orders if it has A

Solution = IF( ISBLANK( CALCULATE(max('Ignore'[Column2]),(ALLEXCEPT('Ignore','Ignore'[Order No.])),'Ignore'[Column2]="A")),1,0)

Now you can filter 1 to get the desired output

 

 

Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you ribisht17 , this is exactly what I was looking for!