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 V : Incremental Aggs

I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so far Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs Continue reading Creative Aggs Part V : Incremental Aggs