Forum Discussion
Dax Calculation Help
Hi folks, I need help creating a dax calculation for people with rights for system a and rights in system b. I have a list of names and a list of rights that each person has. The problem is there are multiple rights for a and multiple rights for b. Please see the table below for Clarification.
| Name | Right Name |
| VB | aaa_121 |
| SU | bbb_123 |
| SU | aaa_123 |
| MN | bbb_0 |
| MN | aaa_0 |
| MN | aaa_121 |
| BC | aaa_121 |
| GM | bbb_123 |
| GM | aaa_123 |
| MJ | bbb_5000 |
| CM | bbb_123a |
| CM | aaa_123a |
| LJ | bbb_5000b |
| JMD | bbb_5000a |
| KC | aaa_123 |
| BI | bbb_4000a |
| BI | bbb_4000b |
| BI | bbb_5000a |
| BI | bbb_5000b |
| BI | bbb_123 |
| BI | aaa_123 |
| WK | bbb_123 |
| WK | aaa_123 |
| DFN | bbb_5000e |
| VAP | bbb_5000b |
| GM | aaa_121 |
| SM | bbb_123 |
| BJF | bbb_5000 |
| SR | aaa_121 |
| SR | aaa_123 |
I need to check whether each person has the same rights in system a as system b.
1 Reply
laurmell , You need to have a name and the right table
example
new table
Dim1 =
Distinct(union(Summarize(Table1,Table1[Name],Table1[Right Name]),Summarize(Table2,Table2[Name],Table2[Right Name]) )
Create a combine column in all three table and use that in join
= [Name] & "-" & [Right Name]
Then create a measure like
only matched
Countx(filter( summarize(Dim, Dim[Name], Dim[Right Name], "_1", Count(Table1[Name]) , "_2", Count(Table1[Name]) ) , [_1] =[_2]), [Name])
