Calculate number of rows in a table when Row Level Security is applied

[Krishnan_47]

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

[ribisht17]

@Krishnan_47 

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

Column = CALCULATE(COUNTROWS(Sheet1),all(Sheet1))

Regards,

Ritesh

[amitchandak]

@Krishnan_47 , As you can not userprincipalname in a column, I doubt that is possible.