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

Intro to Power BI Aggregations

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article Continue reading Intro to Power BI Aggregations

Power BI – Pause/Resume calculations with Apply All feature

Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the Continue reading Power BI – Pause/Resume calculations with Apply All feature