Data modelling and DAX
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
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
Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode … Continue reading Power BI Multiple Aggregations tables
Introduction This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in this series have been developed after working on some of the largest models around. The series will cover : Introduction … Continue reading Creative Aggs Part I : Introduction
