Forum Discussion

MC777's avatar
MC777
New Member
3 years ago
Solved

At least one value marks all values

I need help.

 

I currently have this kind of data (green cells). I would need to add a new column that would contain the value "yes" if there is at least one "yes" for a given order.

 

I hope you understand me.

 

 

 

How can I do that?

 

MC

Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    try to write like this

    Column = 
VAR _order = 'Table'[order]
VAR _RESULT =
    CALCULATE (
        COUNTROWS (),
        FILTER (ALL ( 'Table' ),
                'Table'[order] = _order
                && 'Table'[something] = "yes")
    )
RETURN
    IF ( _RESULT = 1, "YES", "NO" )


1 Reply

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    try to write like this

    Column = 
VAR _order = 'Table'[order]
VAR _RESULT =
    CALCULATE (
        COUNTROWS (),
        FILTER (ALL ( 'Table' ),
                'Table'[order] = _order
                && 'Table'[something] = "yes")
    )
RETURN
    IF ( _RESULT = 1, "YES", "NO" )