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...
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])