Computing accurate percentages with row level security in Power BI

How to compute ratios when row-level security hides some of the data. If the percentage also includes the hidden rows in the comparison, you should customize the data model and the measures involved to get the right result.
Article and download: sql.bi/817079?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@luizkrein]

Thanks!
I was looking for calculation order to understand if it is safe to use calculated table with RLS for my needs and I got this gem!

[@fpa89]

This is gold, thanks

[@katarzynalaskowska4740]

Thanks, I used something silimar a long time ago but I wasn't sure that it was the right one. I thought for sure I am doing something wrong, but this helped a lot.

[@sandeepbarge4699]

Amazing! Thanks for another amazing video.
At first I had thought that it won't work with dynamic row level security if I am implementing dynamic RLS in following manner?
1) Create Users Table.
2) Create Countries Table.
3) Create Users_Countries bridge table.
4) Store Country ID in each dimension and fact tables.
5) Define 1:many single directional relationship between Users and Bridge table.
6) Define 1:many bi-directional relationship between Countries and Bridge table.
7) Define 1:many relationships between Countries and other Dimension and Fact tables.
8) Add role and add filter to it on Users table using USERPRINCIPALNAME() function.
9) In Power BI Service add users to roles in dataset\security settings.
But I guess in this case solution you mentioned at start of the video of creating 1 row table with total sales for entire world will help. Please correct me if I am wrong.

[@sarajvo2010]

So simple, but very great solution! Thank you

[@mathew9665]

I had this exact issue 2-3 years ago - I did a very simular solution - highly recommend this approach

[@maridekanoidze1719]

Thank You SQLBI! I really enjoy DAX because of you ❤

[@nidhisingh4973]

Thank you for another awesome video.

[@tamerjuma]

Amazing! Thank you so much for sharing your magic secrets ❤️

[@Bharath_PBI]

Thank you!

[@JMcLeodKC711]

Another feature that has been around since good old MDX.

[@RandomlyWisdom]

Silent learning was to use ALL and VALUES instead of ALLEXCEPT!