Custom Column that show if condition was met.

[Irek]

Have such table with ID and Yes/No columns, need to add extra column wich will show for True for ID that have Yes against them in Yes/No column, if they have for example 3 yes but one No all should be showed as False.

ID	Yes/No	Result
1	Yes	False
1	Yes	False
1	No	False
2	Yes	True
2	Yes	True
2	Yes	True
2	Yes	True

I tried to do it like that:

Result =

VAR _selectedName =

CALCULATE ( SELECTEDVALUE( table[ID]  ) )

VAR _countName =

CALCULATE ( COUNT ( table[ID] ) )

VAR _countNameFree =

CALCULATE (

    COUNT ( table[ID]),

    FILTER(ALL(table[ID]), (table[ID] = _selectedName ),

           table[Yes/No] = "Yes")

           VAR result =

           IF ( _countName = _countNameFree, TRUE (), FALSE () )

           RETURN

    result

But it shows for ID 1 True for rows with Yes and False for row with No, while I would expect False for all rows with ID 1. 

Thank you for your help. 

Marcin

[vicky_]

You can use this formula: 

Result = IF(CALCULATE(MIN('Table (2)'[Yes/No]), ALLEXCEPT('Table (2)', 'Table (2)'[ID])) = "No", FALSE(), TRUE())

[Irek]

Hi Vicky, Thank you for your respond. Should I replace ID with Yes/No in that part: Table (2)'[ID])) = "No"? Thank you Marcin