Forum Discussion
Need help in filtering data - show only if USERPRINCIPALNAME matches the group of users(topmanagers)
Hi! I have the below table wherein only the TopManagers people can see this data - I tried the following Measures: FilterByTopManagers = IF(CONTAINSROW({USERPRINCIPALNAME()},selectedvalue(Ti...
I have tried to get the data with the below Dax query - it is working however getting filtered with the current logged in user.
What I want is: If TopManagers equal or contains USERPRINCIPALNAME() then show all data.
Using SQL it would be: SELECT * FROM TimeReport WHERE TimeReport[TopManagers] IN (USERPRINCIPALNAME())
New Table =
CALCULATETABLE (
SELECTCOLUMNS (
TimeReport,
"Neukunden_Akquise_Systeme", TimeReport[Neukunden_Akquise_Systeme],
"Neukunden_Akquise_Produkte", TimeReport[Neukunden_Akquise_Produkte],
"User Name", TimeReport[User Name]
),
)