Forum Discussion
Row level security: User should see own data and total
Here is the solution:
https://www.sqlbi.com/articles/implement-non-visual-totals-with-power-bi-security-roles/
Basicaly like mine. I just forgot I can put all measures together and hide additional calculated table (with summarizecolumns).
Hi Dale,
I am not sure I am following you. Or rather I cannot see how one calculated table solves the issue here.
I need to have (let's say) country dimension in order that user from each country can see his/her numbers. At the same user must be able to see total for all countries, but not details for other countries. How can I hide other countries depending on user but at the same time keeping total number for all those countries?
Calculated table or summarized table just calculates totals without one dimension (country for instance). That is what I need, but than I lack details for country of user who is logged in.
Please check my first post.
I would like I am missing the point and that there is a solution. :) But, I just don't see it yet. :(
Best regards
Here is the solution:
https://www.sqlbi.com/articles/implement-non-visual-totals-with-power-bi-security-roles/
Basicaly like mine. I just forgot I can put all measures together and hide additional calculated table (with summarizecolumns).