App status based on component status

[Anonymous]

Hello community,

I need to see the application status based on the component status. Each app consists of several components. As soon one of the component status is red, the whole app status is red. Only if all component status is green, the app status is green as well.

My data:

App.	Comp.	Comp. Status
A-1	SW	green
A-1	HW	green
A-2	SW	green
A-2	HW1	red
A-2	HW2	red
A-3	SW	red
A-4	HW	green

Do you have any suggestions?

Thank you very much in advance. Your help ist very appreciated.

[SpartaBI · Accepted solution]

@Anonymous you can create this measure:

App Status = 
IF(
    HASONEVALUE('Table'[App.]),
    VAR _current_app = SELECTEDVALUE('Table'[App.])
    RETURN
    IF(
        COUNTROWS(
            FILTER(
                'Table',
                'Table'[App.] = _current_app && 'Table'[Comp. Status] = "red"
            )
        ) > 0,
        "red",
        "green"
    )
)

Showcase Report – Contoso By SpartaBI

     

[Anonymous]

rry I checked badly the firs formula,

Here is the good one

Status =

var App='status app'[App.]

var result2=countrows(filter(summarize('status app','status app'[App.],'status app'[Comp. Status]),'status app'[App.]=App&&'status app'[Comp. Status]="Red"))

return

if (result2=0,"Ok","Not Ok")

[Anonymous]

Hi,

try this. I added a cloumn to the table

[tamerj1]

@Anonymous 
You can slice by App. then New Measure:
Status =
IF ( COUNTROWS ( VALUES ( TableName[Comp. Status] ) ) = 1, "Green", "Red" )