Until now, I have not been very successful with building a perfect KPI visual that would meet my criteria of being able to show the three critical data points that define a KPI for me: Actual ValueTarget ValueTrend (UP, DOWN, SAME) The out of the box KPI visual has so many limitations that I should … Continue reading Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)

As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page. You can select what measure you would like to see in bars for example and which one should go into a line. … Continue reading How to Build a Multi-KPI Comparator Using Calculation Groups (Power BI DAX Tutorial)

I am not trying to take Microsoft out of business, but after I read on the Power BI team's blog that the anomaly detection feature was coming, I decided to see if I could implement something like this myself using DAX. Turns out we can build something very useful without having to run regressions and … Continue reading Anomaly Detection Calculation Using DAX (Power BI Tutorial)

A few posts ago I talked about KPIs and how they can be significantly improved by adding a trend. The question is, however, can we do even better? Can we have a current value, a target and a trend and still add more color to a KPI? Turns out that we can, and we can … Continue reading Supercharge KPIs with Rankings (When Trend And Target Are Not Enough) (Plus a RANKX() DAX Function Tutorial)

Imaging a scenario where your monthly sales are $80 while the budge value for sales was supposed to be $100. Obviously, you are not making your number. However, would you rather be 20% short but with sales trending up or 20% short but sales trending down? I think that most people would agree that the … Continue reading Custom KPI Trend Calculation – UP ↑ – DOWN ↓ – or About The Same → (PowerBI DAX Tutorial)

I just recently did a video tutorial for CONTAINSROW() function. In that video I was taking a look at the coupon redemption data with a goal of determining how much fraud was occurring across various retailers. One of the subscribers commented on the video that this problem could have been solved with the INTERSECT() DAX … Continue reading CONTAINSROW() vs. INTERSECT() Power BI Functions: Pros and Cons and When to Use

Some things are just not that easy to calculate. Let us take headcount for example, if I had ten people in my department in January, February, and March, then my Q1 headcount is not thirty it is still ten. So with sales we can just sum all the data up, but with things like headcount, … Continue reading Working with Inventory, Balancesheet and Headcount Type Data (Semi-additive measures and LASTNONBLANKVALUE() Power BI DAX Tutorial)

Can we do a CONTAINSROW() DAX function tutorial while implementing a coupon redemption fraud detection calculation? Yes! Can we add to this a discussion about how to calculate distinct counts on temp tables? You betcha! In fact, we can do it all in one video. The dataset is simple, we will take a look at … Continue reading CONTAINSROW() DAX Function Tutorial (is DAX CONTAINSROW() = WHEN EXISTS() in SQL?), Plus a Fraud Detection Calculation

There are many videos on YouTube already dedicated to this topic. So why am I doing another one? Well, the goal here is not to teach you Row Level Security. My goal is to help you understand how Row Level Security works. In this video I will discuss what makes row level security work in … Continue reading The Very Basics of Row Level Security (RLS – Power BI Tutorial)