I need to filter my table by using the managing roles. When I try to use the DAX command in a calculated column, it works perfectly fine. However, in my manage roles the DAX is not working. Basically, I want to filter the Brand = "DEF" with their ItemId that Ends with "G". In manage roles, the brand wouldn't even show up in the report when role testing conducted.
Hi @amitchandak yes I do select the role. However, brand DEF does not appear in the report when I select and test the role. I need to filter multiple field which comprehend Brand must be DEF AND the item code must ends with G.