Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help with DAX

Hi all ,

I'm unable to get the logic to implement in DAX for one of the queries that I have. 

Scenario:

I've 3 columns namely "Report_Name", "User_List" and "User_status".

if a report is shared with 3 users and out of these 3, any 1 user is active from the User_List then I need the output as "Retain". If all the user's status is Inactive, I need the output as "Delete".

Below is a sample of the data:

Report_NameUser_ListUser_statusOutput
Report1User1ActiveRetain
Report1User2ActiveRetain
Report1User3ActiveRetain
Report1User4InactiveRetain
Report1User5InactiveRetain
Report2User6InactiveDelete
Report2User5InactiveDelete
Report2User7InactiveDelete
Report2User8InactiveDelete

Any help with this is appreciated. Thanks in advance!!

Regards
Mahesh

Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Anonymous 

    output

    Column = 
var r = Table2[Report_Name]

var f= 

FILTER(
    Table2,
    Table2[Report_Name] = r && Table2[User_status] = "Active"
)

return
IF(ISEMPTY(f),"Delete","Retain")

     

    let me know if this works. 

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

1 Reply

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    Anonymous 

    output

    Column = 
var r = Table2[Report_Name]

var f= 

FILTER(
    Table2,
    Table2[Report_Name] = r && Table2[User_status] = "Active"
)

return
IF(ISEMPTY(f),"Delete","Retain")

     

    let me know if this works. 

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠