Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi
I have a table with One of the column having below records
UTX
UTV
UTVV
LTX
LTVV
I want to create a RLS where user can see the records related to UTX,UTV,UTVV. ActuaL data is much more so technically I need something like UT* in DAX.
a user can see all data related to UT*
Solved! Go to Solution.
@Anonymous ,
Add new role and assign this rule:
containsstring([Text],"UT")
[Text] is column which contains this data.
image 1 - rule
image 2 - view as role
image 3 - view by default
@Anonymous ,
Add new role and assign this rule:
containsstring([Text],"UT")
[Text] is column which contains this data.
image 1 - rule
image 2 - view as role
image 3 - view by default
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 136 | |
| 111 | |
| 58 | |
| 43 | |
| 38 |