Power BI — Filter Considerations

Peter Hui
4 min readOct 22, 2020

…FILTER, KEEPFILTER and CALCULATETABLE functions

Photo by Georg Eiermann on Unsplash

While I was studying for the DA100 I came across this Microsoft article.

This article suggests you actually AVOID using the FILTER function. HOW? WHY?

I have always used FILTER with almost 90% of the measures I create. It’s just very easy to understand. Coming from an Excel background, I would think that…

--

--

Peter Hui

I write about Power BI, Power Automate and other cool Microsoft power tools. Microsoft certified data analyst. Constant learner and an aspiring writer. 👍