Forum Discussion

Anonymous's avatar
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's avatar
    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
     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

HI Anonymous ,

 

Create a column as below:-

 

Overall status = 
    var result = COUNTROWS(FILTER('Table','Table'[status] = "Fail" && 'Table'[Name]= EARLIER('Table'[Name])))
    return IF(result>0,"Fail","Pass")

 

Output:-

 

Regards,

Samarth