Forum Discussion

lathaaa's avatar
lathaaa
Frequent Visitor
4 years ago
Solved

IF condition based on two columns

Hi All, need help on writing DAX the logic should be if that particular ID is only Failed - 0, only Success - 1, Success & failed - 2, Success & Failed & reprocess - 3 the expected column should be...
Need Help
  • lathaaa's avatar
    lathaaa
    4 years ago

    AntonioM , got the solution by using this DAX code

    var statuses = CALCULATETABLE(VALUES(T_Invoice[Check]),T_Invoice[Report_ID] = EARLIER(T_Invoice[Report_ID]), ALL(T_Invoice) )

    Thank you 🙂
AntonioM's avatar
AntonioM
Solution Sage
4 years ago

lathaaa Could you show me what you're getting when you've tried that? The line

var statuses = CALCULATETABLE( VALUES('Table'[Status]), ALL('Table'[Status]) )

should keep the filter on ID and check for all statuses. Do you have any other other columns in the table?

lathaaa's avatar
lathaaa
Frequent Visitor
4 years ago

AntonioM , got the solution by using this DAX code

var statuses = CALCULATETABLE(VALUES(T_Invoice[Check]),T_Invoice[Report_ID] = EARLIER(T_Invoice[Report_ID]), ALL(T_Invoice) )

Thank you 🙂