Forum Discussion

Pulkit's avatar
Pulkit
Resolver I
9 years ago
Solved

Using Measures in Filters

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.

  • 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

3 Replies

  • prateekraina's avatar
    prateekraina
    Memorable Member

    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's avatar
      Pulkit
      Resolver I

      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's avatar
        prateekraina
        Memorable Member

        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