Forum Discussion

NiugeS's avatar
NiugeS
Icon for Helper V rankHelper V
6 years ago
Solved

Help with Query - Countif Valid / Not Valid

Hi, I have 3 columns.  1st column is a group that consists of people who have a category of valid or not valid.  I am trying to work out how I can make an additional column that will say if each g...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    NiugeS 

    Add the following Column to your table:

    Valid Member = 

IF(
    CALCULATE(
        COUNTROWS('Table'),
        ALLEXCEPT('Table','Table'[Group]),
        'Table'[Valid] = "Valid"
    ) > 0 ,
    "Yes",
    "No"
)

     

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

     



Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

NiugeS - You could create a measure like this:

Has Valid Member = 
  VAR __Group = MAX('Table'[Group])
  VAR __Table = FILTER('Table',[Group] = __Group && [Valid] = "Valid")
RETURN
  IF(ISBLANK(__Table),"No","Yes")

As a column the same thing would be:

Has Valid Member = 
  VAR __Group = 'Table'[Group]
  VAR __Table = FILTER('Table',[Group] = __Group && [Valid] = "Valid")
RETURN
  IF(ISBLANK(__Table),"No","Yes")