Using Measures in Filters

[Pulkit]

Hi everyone,

I created some measures in my power bi report and now want to enter them in report filters but I am not able to do so. Is it possible to do so? If yes, how? 

Also I am not able to create a join from measure to any column.

[prateekraina]

Hi @Pulkit,

This is not possible.
Can you explian what you are trying to do so that an alternative can be suggested.

Prateek Raina

[Pulkit]

Hi @prateekraina

I want to achieve row level security through it without using the roles feature because when I publish my report in a workspace and then workspace is in edit mode then all the users that are the part of the workspace can see all the data and I know that power bi intentionally does it but I want to hide some data according to the users. Thanks

[prateekraina · Accepted solution]

Hi @Pulkit,

Even if you achive this somehow using measures, you still wont be able to hide data from users who have edit permission in workspace. That is how it is designed.

Prateek Raina