Tag: CALCULATETABLE

Who Are Your Top 20% Of Customers Based On Any Metric – Quality Power BI Insights

I wanted to be able to drill into a specific subset of my customers – in this particular case – I decided to delve into the top 20% as it was most relevant to my analysis, and follows on from a previous tutorial about the Pareto principle – also known as the 80/20 rule. Not

Continue reading

Deep Dive Into The CALCULATETABLE Function – An Important DAX Formula To Understand Well

The CALCULATETABLE function is an incredibly important DAX function to learn and understand well. Most of you who are just starting out with Power BI, have probably glanced over this particular function (I certainly did when I first started out using Power BI and writing DAX measures). It’s quite a complex function to understand and

Continue reading