Forum Discussion
NiugeS
Helper V
Helper VHelp 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...
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 🙂
Fowmy
Super User
Super UserNiugeS
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 🙂