Forum Discussion
hyreddy_016
Microsoft Employee
Microsoft EmployeeMeasure referring to a column restricted using Column Level Security
I have a use case where I need to evaluate a count based on the column filtered in a report. If the visuals are sliced using A or B, the count should evaluate to 0 else 1. Following are more details...
daxer-almighty
Solution Sage
Solution SagePersonally, I think you CAN'T have a measure, which uses restricted columns, return a value for a role that does not have access to the columns/tables. But I may be incorrect as I'm not a specialist in this topic. You could try to ask Alberto Ferarri or Marco Russo. Or Chris Webb. They'll know much more on this than I do.
hyreddy_016Thanks daxer-almighty , is there any other way we can acheive this functionality? Without using the restricted columns in the measure directly? Like same using Row Level Security instead of column level security.