topic Re: Categorize by one of the values in DAX Commands and Tips

Categorize by one of the values

Anonymous — Thu, 23 Sep 2021 15:56:31 GMT

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.

Re: Categorize by one of the values

Greg_Deckler — Thu, 23 Sep 2021 16:09:55 GMT

Anonymous Maybe MIN([IsError])?

Re: Categorize by one of the values

Anonymous — Fri, 24 Sep 2021 05:25:12 GMT

Hi, Greg_Deckler .

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

Re: Categorize by one of the values

VahidDM — Fri, 24 Sep 2021 06:04:23 GMT

Hi Anonymous

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✌️!!

Re: Categorize by one of the values

Greg_Deckler — Fri, 24 Sep 2021 13:33:24 GMT

Anonymous 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])

Re: Categorize by one of the values

Anonymous — Fri, 01 Oct 2021 06:21:31 GMT

Thank you, Greg_Deckler and VahidDM .

I applied the following and that seems to work:

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