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 USERPRINCIPALNAM...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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
    7 years ago

    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
      7 years ago

      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