Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Computing accurate percentages with row level security in Power BI

SQLBI
120K subscribers
7.6K views 1 year ago
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: https://sql.bi/817079?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more
...more
Computing accurate percentages with row level security in Power BI
229Likes
7,667Views
2023Nov 21
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: https://sql.bi/817079?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Follow along using the transcript.

SQLBI

120K subscribers