Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

DAX calculation

In the above table i want a column "Overall Status" next to Status, which should show 'Pass' or 'Fail' for each Name. Condition : Show 'Pass' only if the person have Pass in all subject els...

Need Help

selimovd
4 years ago
Hey Anonymous ,

sure, you can expant the criteria for other cases.

You could separate them with the double pipe "||" or you use the IN operator:

Overall Status = IF ( CALCULATE ( COUNTROWS ( MyTable ), ALLEXCEPT ( MyTable, MyTable[Name] ), MyTable[Status] IN { "Fail", "N/A", BLANK () } ) > 0, "Fail", "Pass" )

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

selimovd

Most Valuable Professional

4 years ago

Hey Anonymous ,

sure, you can expant the criteria for other cases.

You could separate them with the double pipe "||" or you use the IN operator:

Overall Status =
IF (
    CALCULATE (
        COUNTROWS ( MyTable ),
        ALLEXCEPT ( MyTable, MyTable[Name] ),
        MyTable[Status] IN { "Fail", "N/A", BLANK () }
    ) > 0,
    "Fail",
    "Pass"
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic