Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

App status based on component status

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 r...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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")