Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to set a Page Level Filter, with the Advanced Filter with a column that compares to a Measure

I have a table: Department containing the columns: 'DepartmentName', 'Domain', and others. I also have a Measure: 'Measure_UserDomain' in the same table that invokes the DAX function USERPRINCIPALNAME() that returns the currently logged in user's email address. I have tweaked this using a DAX expression to retreive the domain portion from the email address (the part after the @symbol, eg: "[email protected]" would return "Dept1.com"). The 'Domain' column contains the Department's domain such as the value "Dept1.com", "Dept2.com", etc.

I have a Slicer pointing to the 'Department'[DepartmentName] that lists the various Departments. How do I set a filter to this Slicer so that the Visual Level, or Page Level or Report Level filter with the Advanced Filtering type display only the values that match 'Department'[Domain] = 'Department'[Measure_UserDomain], since the 'contains' option only allows one to hard code the value to filter on rather than a dynamic filter.

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi Anonymous ,

    I still have a little confused about your scenario.

    If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

    Best  Regards,

    Cherry

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Cherry Gao for your response. What I meant in my last message was how do I filter by comparing the column value to a calculated Measure. See the highlighted picture for more details. Let me know if this is sufficient to understand the issue.

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar

        Hi Anonymous ,

        By my research, we cannot do that in power bi currently.

        The text box only can be entered with the a fixed value.

        You could submit your idea in Power BI ideas Forum and add your comments there to improve Power BI and make this feature coming sooner.

        Best Regards,

        Cherry