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...
amitchandak
Super User
Super UserAnonymous , My advice is, if possible, split the TopManagers column in power query into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi Amit,
I gave it a try however it doesn't look optimal - TopManagers values get split into columns so it can be 2 or 3 or 5 columns as I am getting the Top Managers of a user dynamically as per the Organization Chart.
Therefore evaluating how many top managers would a user have and then querying all these columns would be tedious hence dropping this idea.