Forum Discussion
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 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.
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" ) )
4 Replies
- SpartaBI
Community Champion
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" ) ) - tamerj1
Anonymous
You can slice by App. then New Measure:
Status =
IF ( COUNTROWS ( VALUES ( TableName[Comp. Status] ) ) = 1, "Green", "Red" )
