Roles : define and filter

[Myrmelia]

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

[Myrmelia]

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]

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]

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 

[Anonymous]

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.