March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi All,
I have a table in Data View. It contains one column (Country). I need to create a new column which should contain the number of rows in the table. Now when a user who has access to two countries, he should see only two countries with 2 as value in the new column. Please note that I do not want to create a measure but a new column in the exisiting table.
Country | Column in Table (Row Count) |
Aus | 4 |
Eng | 4 |
SG | 4 |
US | 4 |
After Applying Row Level Security Access:
Country | Column in Table (Row Count) |
Aus | 2 |
Eng | 2 |
I think it's okay for you to have security in the measure.
After that, you need to Calculate the number of rows in your table as a Column
Regards,
Ritesh
@Krishnan_47 , As you can not userprincipalname in a column, I doubt that is possible.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |