Speed up Distinct Count calculations in Power BI using Aggregations

This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well Continue reading Speed up Distinct Count calculations in Power BI using Aggregations

Using PowerShell to create Calculation Groups in Power BI Desktop

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

Power BI Storage Modes for Aggregations

Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model Continue reading Power BI Storage Modes for Aggregations