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
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".
Report_Name | User_List | User_status | Output |
Report1 | User1 | Active | Retain |
Report1 | User2 | Active | Retain |
Report1 | User3 | Active | Retain |
Report1 | User4 | Inactive | Retain |
Report1 | User5 | Inactive | Retain |
Report2 | User6 | Inactive | Delete |
Report2 | User5 | Inactive | Delete |
Report2 | User7 | Inactive | Delete |
Report2 | User8 | Inactive | Delete |
Solved! Go to Solution.
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! 🤠
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! 🤠
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |