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.
Hello Everyone,
We are working on creating Dynamic RLS for one of our reports, and we are facing issues in DAX. Below is the DAX, It is working fine if we remove IF condition. But if we use IF condition with CalculateTable the results are not as expected.
[region] IN IF(CONTAINS(analytics_auth1, [emailid], USERPRINCIPALNAME(), [access_type1], "Region"),
CALCULATETABLE( SELECTCOLUMNS(analytics_auth1, "level1", [level1]), FILTER(analytics_auth1, [emailid] = USERPRINCIPALNAME())), [region] )
Please let me know your suggestions why it is not working with IF condition.
Thank you in advance.
Arvind
Hi @Anonymous ,
Please provide some dummy data, and show us the difference of the result return by formula with IF condition and without IF condition. If using IF condition, is there any error?
Regards,
Yuliana Gu
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |