Forum Discussion

itsme-stephanie's avatar
itsme-stephanie
Frequent Visitor
5 years ago
Solved

Exclude whole group if value is found #2

Hi all,   I'm facing almost the same problem, as explained here, except that I want to exclude the whole group (Column Item/ group = AA/BB/ etc) if the value X (Column Code) is found. So if we wou...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI itsme-stephanie ,

     

    Let me know if this is what you are looking for.

     

    Create a new measure

     

    IsValidCOlumn = IF( CALCULATE(COUNTROWS(Table4),FILTER(Table4,Table4[Code] = "X")) >=1,"False","True")

     

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI itsme-stephanie ,

 

Let me know if this is what you are looking for.

 

Create a new measure

 

IsValidCOlumn = IF( CALCULATE(COUNTROWS(Table4),FILTER(Table4,Table4[Code] = "X")) >=1,"False","True")

 

 

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)