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


         

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
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