Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Maheshguptaz
Helper III
Helper III

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

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@Maheshguptaz 

output

Daniel29195_0-1708686303607.png

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! 🤠

View solution in original post

1 REPLY 1
Daniel29195
Super User
Super User

@Maheshguptaz 

output

Daniel29195_0-1708686303607.png

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! 🤠

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.