View My Drafts
Please can someone help with a row level security query.
I have the following tables
I need to create a DAX formula to allow row level security on Entity B for the following logic
If a user is not in Entity A table then the user should be restricted to see only records where Icon <> C. If the user is in Entity A then they will have access to all records in Entity BAny help much appreciated
CurrentUser = USERNAME()
VAR _entityAMatchedRows =
'Entity A'[User] = [CurrentUser]
COUNTROWS(_entityAMatchedRows) > 0
3. And third, I would create a measure to determine whether to show a given row in the current filter context:
VAR _currentIcon =
_currentIcon <> "C"
And then you can create a simple table visual to show Entity B, and use the [DisplayRow] measure as a filter on that visual: