Under each of the category, to return True if there's a value of fail in that category

[Anonymous]

Here's the sample data

Table:data

Expected result:

I found a similar post in the community and tried to follow the solution, yet, I couldn't approach the result as I expected.

Thanks

[Jihwan_Kim · Accepted solution]

Creating a new column.

Result CC =

SWITCH (

TRUE (),

COUNTROWS (

FILTER ( Data, EARLIER ( Data[ID] ) = Data[ID] && Data[Status] = "fail" )

) > 0, "FALSE",

"TRUE"

)

https://www.dropbox.com/s/f2fw4n4kme25vlw/jmywang.pbix?dl=0 

[AlB · Accepted solution]

Hi @Anonymous 

If it is a calculated column that you are after:

NewCol =
NOT "Fail"
    IN CALCULATETABLE ( DISTINCT ( Table1[Status] ), ALLEXCEPT ( Table1, Table1[Id] ) )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Jihwan_Kim · Accepted solution]

Creating a new column.

Result CC =

SWITCH (

TRUE (),

COUNTROWS (

FILTER ( Data, EARLIER ( Data[ID] ) = Data[ID] && Data[Status] = "fail" )

) > 0, "FALSE",

"TRUE"

)

https://www.dropbox.com/s/f2fw4n4kme25vlw/jmywang.pbix?dl=0