Get a page or visual filter to be applied to a variable value

[Syndicate_Admin]

Hello, I know that I do not know You can perform a per-role filter (RLS) in Power BI at the page level of a report.

I need an alternative method, ut powerilizar a direct filter on a page in question but that the value to filter was variable, I do not know if it is possible with DAX.

The fact is that I have a table of users and their departments, and I have achieved a measure (combining lookupvalue and userprincipalname) that gets me the department of the current user. This would be the value for that page filter, but I don't know how to mount it to apply.

I also tried a calculated column in that table, but it fails, the userprincipalname function is not allowed.

Let's see if anyone can think of any way, thanks in advance and greetings.

[amitchandak]

@Syndicate_Admin , Measure can only be filtered at a visual level.

You can create Dynamic segmentation, but all visuals need to use measures following the independent table used in Dynamic segmentation

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q