Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Thank you, @Greg_Deckler and @VahidDM .
I applied the following and that seems to work:
@Aleksandra_MLT Maybe MIN([IsError])?
Hi, @Greg_Deckler .
IsError is my desired output. So I used MIN([Status]) and it creates a column with "Error" value only.
@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])
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✌️!!
Thank you, @Greg_Deckler and @VahidDM .
I applied the following and that seems to work:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |