Search code examples
powerbidax

Filter slicer using a measure

In my report I use two tables "NomData" and "ReadData_Perm".
enter image description here

I have a measure to identifie my needed EventTypeCodes by UserLogin:

FilterEventByUser = 
IF(
    MAX(dlg_V_User_ReadData_Perm[UserLogin]) = USERPRINCIPALNAME()
    && MAX(dlg_V_User_ReadData_Perm[EventTypeCode]) = MAX(Nomenklaturen[EventTypeCode])
    //MAXX(dlg_V_User_ReadData_Perm, dlg_V_User_ReadData_Perm[UserLogin]) = USERPRINCIPALNAME()
    //&& MAXX(dlg_V_User_ReadData_Perm, dlg_V_User_ReadData_Perm[EventTypeCode]) = MAXX(Nomenklaturen, Nomenklaturen[EventTypeCode])
   , 1, 0
)

When I use this measure as a filter on a table-visual it works just fine.
enter image description here enter image description here

But when I apply the same filter on a Slicer all my EventTypeCodes disappear.
enter image description here

As you can see I have tried MAX and MAXX but it works only on the table-visual. How can I apply the measure as a filter for my slicer?

Please let me know. Here is some example data (Replace Jessica@test.org with you Login for testing):

EventTypeCode;Account
11;Piers
11;Elizabeth
13;Neil
13;Melanie
13;Joshua
14;Madeleine

UserLogin;EventTypeCode
Christian@test.org;11
Christian@test.org;14
Jessica@test.org;13
Solution

  • My problem seams to be the USERPRINCIPALNAME(). Row level security made the problem obsolete.