In my report I use two tables “NomData” and “ReadData_Perm”.
I have a measure to identifie my needed EventTypeCodes by UserLogin:
<code>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
)
</code>
<code>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
)
</code>
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.
But when I apply the same filter on a Slicer all my EventTypeCodes disappear.
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 [email protected] with you Login for testing):
<code>EventTypeCode;Account
11;Piers
11;Elizabeth
13;Neil
13;Melanie
13;Joshua
14;Madeleine
UserLogin;EventTypeCode
[email protected];11
[email protected];14
[email protected];13
</code>
<code>EventTypeCode;Account
11;Piers
11;Elizabeth
13;Neil
13;Melanie
13;Joshua
14;Madeleine
UserLogin;EventTypeCode
[email protected];11
[email protected];14
[email protected];13
</code>
EventTypeCode;Account
11;Piers
11;Elizabeth
13;Neil
13;Melanie
13;Joshua
14;Madeleine
UserLogin;EventTypeCode
[email protected];11
[email protected];14
[email protected];13