Category: Distinct Count

Speed up Distinct Count calculations in Power BI using Aggregations

Posted on 2 Comments on 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

DAX : Approx Distinct Count

Posted on 8 Comments on DAX : Approx Distinct Count

Introduction For this blog, I want to share an interesting approach that can potentially speed up slow reports that include a distinct count calculation. The approach described in this article explains how you can add a DIY version of an approximate distinct count calculation to a DAX based model. The method combines a little pre-processing … Continue reading DAX : Approx Distinct Count