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

Creative Aggs Part II : Horizontal Aggs

Introduction to Aggs Horizontal Aggs (this article) Mixing Agg and base table to produce a single value Accordion Aggs Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart Continue reading Creative Aggs Part II : Horizontal Aggs