Is there a way to group by ID and assign a value if at least one row is not blank?

[user35131]

I have a table that looks like this. Note that I want to group by "ID". ID 3 has all blanks so it doesn't fit the criteria. 1 does because at least one value is not blank. 2 also fits the criteria since one row is not blank.

ID	Value
1	3
1	3
2	4
2
3
3
3
4	5

I would want the result to look like this

ID	Value	Result
1	3	Yes
1	3	Yes
2	4	Yes
2		Yes
3		No
3		No
3		No
4	5	Yes

[Ahmedx]

also possible like this:

Column = 
VAR _currentvalue = [ID]
VAR _Results=
    
        CALCULATE (
            COUNTROWS (),
            FILTER ( 'tbl', 'tbl'[ID] = _currentvalue && ISBLANK ( 'tbl'[Value] ) ))
            RETURN
if (_Results >= 2,"NO","YES")

[Nathaniel_C]

Hi @user35131 ,

Like this?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C]

Hi @user35131 ,

Let me know if this works for you.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Original Table

Add Index to keep original order

Group rows as above

Expand Detail

Add Conditional column

Then I renamed it and changed types.

[Ahmedx · Accepted solution]

this is how you can

Столбец = 
 VAR _currentvalue = [ID]
 ВАР _Результаты=
    
         ВЫЧИСЛИТЬ (
             СТРАНЫ (),
             ФИЛЬТР ( 'таблица', 'таблица'[ID] = _currentvalue && IПУСТО ('таблица'[значение] ))
             ВОЗВРАЩАТЬСЯ
             ЕСЛИ( ЕСТЬПУСТО(_Результаты)||_Результаты=1,"ДА",
     "НЕТ"
  )