Categorize by one of the values

[Aleksandra_MLT]

Hi all. Seemed simple one but got stuck here:

There is a list of devices (ID) which can send an error or informational event. Some ID's can have both status messages. What I would like to do is categorize them in a way so if there is an error and informational event for same ID, it would say 'error'. Kind of ranking.

Both M and Dax solutions are welcome. Thank you in advance.

[Greg_Deckler]

@Aleksandra_MLT Maybe MIN([IsError])?

[Aleksandra_MLT]

Hi, @Greg_Deckler .

IsError is my desired output. So I used MIN([Status]) and it creates a column with "Error" value only. 

[Greg_Deckler]

@Aleksandra_MLT Yeah, my thought was a measure and you are correct, I meant MIN([Status]), If a column you could do:

MINX(FILTER('Table',[ID]=EARLIER([ID])),[Status])

[VahidDM]

Hi @Aleksandra_MLT 

Try to add a column with this DAX code:

IsError = 
VAR _Error =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Status] ),
        ALLEXCEPT ( 'Table', 'Table'[ID] )
    )
RETURN
    IF ( _Error > 1 || 'Table'[Status] = "Error", "Error", "Informational event" )

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[Aleksandra_MLT · Accepted solution]

Thank you, @Greg_Deckler and @VahidDM .

I applied the following and that seems to work:

=CALCULATE(MIN('Table'[Status]) ,ALLEXCEPT('Table', 'Table'[ID]))