Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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: "Abe@Dept1.com" 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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |