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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Maheshguptaz
Helper II
Helper II

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.