Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have an odd situation. I have a couple of roles setup namely Management, Operations and Brokerages.
The Brokerage role has a look at the USERNAME() sent through from the embedded application for the right brokerage and then filters according to that.
One of the managers recently requested that a user should be able to be a member of multiple brokerages.
Is there a way to filter the DAX expression by splitting the string of USERNAME() and running a OR clause? Or how should I go about this.
example:
So let's say John is part of Brokerage 1 but needs to be added to Brokerage 2 as well but not see Brokerage 3's filtered dashboard.
Normally I would send through 'Brokerage 1' ass the Username and the dashboard would be filtered to only show Brokerage 1's results. This is achieved by using the DAX expression [Brokerage] = USERNAME()
Hi @Francol3 ,
Using Or function should work well in your scenario. Could you please share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |