Forum Discussion

Myrmelia's avatar
Myrmelia
Regular Visitor
2 years ago

Roles : define and filter

Hello, 

 

I've encounter a problem while I tried to define role by table filter. It return to me an error message :

It happens on PBi desktop and always on third and forth tables. First and second : on 1st and 2d, the filter DAX expression registered correctly but on third and forth same filter on "Entreprise" dysfunction and appears like that capture ? 

What happens ?

Thanks

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Myrmelia ,

     

    You can try changing the expression to:

     

    [id] == "Objectifs de l’année écoulée"

     

    If this does not solve your problem, please provide your DAX expression.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

  • Myrmelia's avatar
    Myrmelia
    Regular Visitor
    2 years ago

    Hi,

     

    Thanks for your support,

    I obtain that on tables 3 and 4 :

     

    And I can't type anything on grey window,

     

    On tables 1 and 2, I be able to type that and it's works well :

     

     

    What can I do ?

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Myrmelia ,

       

      You can try to delete all the model relationships in Table 3 and Table 4 and observe again if they are still grayed out.

       

      Best Regards,

      Neeko Tang

      If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

      • Myrmelia's avatar
        Myrmelia
        Regular Visitor
        2 years ago

        Hi,

         

        I've must delivered my report yesterday with sharings so I've created third copies with line filters on enterprise in powerquery .

         

        I'm afraid to disturb my sharings with your soluce so I'll try it in another report more later. 

         

        Thanks very much and have a good day