Forum Discussion
Microsoft EmployeeRows that match or do not match based on
I have the following data:
I wish to know if per DB the Match field in every Srv. e.g.
Stated another way.. the DB must have the same login across all servers (finding the server in the cluster that does not have all the logins as the other servers)
| DB | SrvDb | db_owner | db_denydatawriter | db_datawriter | db_datareader | Match |
| DbB | Srv1 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
| DbB | Srv2 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
| DbB | Srv3 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
| DbC | Srv1 | DbC | 1 | 0 | 2 | 1 | 1,1,2,0 |
| DbC | Srv2 | DbC | 1 | 0 | 1 | 1 | 1,1,1,0 |
| DbC | Srv3 | DbC | 1 | 0 | 2 | 1 | 1,1,2,0 |
Thank you PhilipTreacy for your prompt reply.
Hi CharlotteCity12 ,
Based on the information you provided, I have created a sample data and you can follow the steps below:
1. Add a new column.Mis = VAR _DB = 'Table'[db_owner] & "," & 'Table'[db_denydatawriter] & "," & 'Table'[db_datawriter] & "," & 'Table'[db_datareader] RETURN IF ( 'Table'[Match] = _DB, "Match", "No Match" )Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- PhilipTreacy
Super User
Not clear what you want. What login are you referring to? I dno't see anything in your data.
Please supply a clear example of the desired result.
Phil
Thank you PhilipTreacy for your prompt reply.
Hi CharlotteCity12 ,
Based on the information you provided, I have created a sample data and you can follow the steps below:
1. Add a new column.Mis = VAR _DB = 'Table'[db_owner] & "," & 'Table'[db_denydatawriter] & "," & 'Table'[db_datawriter] & "," & 'Table'[db_datareader] RETURN IF ( 'Table'[Match] = _DB, "Match", "No Match" )Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
