Now that we’ve established the why and how of Dax aggregations, let’s dive into applications. Specifically, how we might pair this with Row Level Security. Or at least how I did pair it with RLS. This post assumes you have read part 1. You have been warned.

Aggregations are one of my favorite new features added to Power BI in 2018. Adam thinks so too. The quick summary is that if you have two tables about the same facts at different levels of detail, Power BI can intelligently choose which one to use for each query to get the best performance. This article is about aggregations. If you don’t already know about them, you should learn more about them here and here and lots of other places first.