Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Return rows based on multiple IF conditions

HI all,   My Projecttable looks like this   Projectcode type Customer Extra columns A1 1 Jill bla bla A2 2 Jill bla bla A3 1 Joe bla bla A4 2 Joe bla bla A5 3 J...
Need Help
Need Help DAX
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , add this measure along with other columns in a visual

     

    calculate(countrows(Table), filter(Table, (Table[Type] <> 1 && Table[Customer] = "Jull") || ( Table[Type] <> 2 && Table[Customer] = "Joe")))

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

Anonymous , add this measure along with other columns in a visual

 

calculate(countrows(Table), filter(Table, (Table[Type] <> 1 && Table[Customer] = "Jull") || ( Table[Type] <> 2 && Table[Customer] = "Joe")))