I have been using disconnected slicers for quite some time. What I love about them is that you can use them so that a user does not have to go to individual pages to view different measures or valu…

Having read this question on the mdsn blogs , I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team of SSAS and Marco Russo who

I recently wrote an article to described in more details the syntax of the IN operator in DAX , which is available in Power BI and in the CTP of the next re

This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. The ne

This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. A very popular DAX functio

I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always

Would it not be nice if your Title changed based on what you selected on your slicer? In this example below I am going to show you how I used a Country slicer to dynamically change the title of my …

Powerful and all that CALCUATE is, there is a limitation to the filters that it can apply. In this article we will look at one of these limitations

Context Transition in DAX is when you transform the row context into the filter context.  In order to understand Context Transition a practical knowledge of Row and Filter context is needed, along with a practical knowledge of CALCULATE. Understanding Context Transition is not too complicated, however it is something that DAX users get caught out […]

I cannot tell a lie.  Nah… that’s a lie.  I just lied.  But I am speaking truth here… I’m excited to write this post today!  I get the rare joy of sharing something cool with you… while doing my favorite thing… complaining about stuff! We are going to talk about the KEEPFILTERS function. Before I …

A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon…

Update: 16 December 2016 (I got a comment from Marco Russo, who suggested that can use the FILTERS DAX Syntax which will “Return a table of the filter values applied directly to the specified…

Where I am currently consulting there was a requirement to create a measure like you can in the Excel pivot tables for the % of Column Total or the % of Row Total. One of the things that you can cu…

The quick measure calculates the Pearson correlation coefficient between two measures within the category.   NAME: Correlation coefficient   DESCRIPTION: Calculate the Pearson correlation coefficient between two measures within the category   PARAMETERS: Name: Category Tooltip: The category in which...

This measure calculates a rolling average. It takes a set number of periods before and after the current filter context and does an average over those values.    Name: Rolling average Description: Calculate the average of the value for a set number of periods before and after the filtered date  Para...

PowerPivot's EARLIER function is a powerful way to calculate values based on rows that similiar to the row currently being evaluated.

Varface – Say hello to my little friend I used to use the bad joke, “CALCULATE is the Ummmm of DAX” – like, when you want to start talking/writing out a DAX expression before you really know the answer, you just start typing CALCULATE slowly cuz you know it’s coming – it always does!But now, …

If you want to reach into a difference table in DAX you will need to use either the RELATED or the RELATEDTABLE expressions.

Below I am going to explain some of the caveats that you need to be aware of when implementing Dynamic Row Level Security (RLS) in Power BI. Without this I could not get Dynamic RLS security working for me and my data.   I found that there are a few things that are currently not mentioned anywhere...

This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in

With the new Power BI desktop release (July 2017) comes a new DAX function called “SelectedValue”, this DAX function is a convenience feature to help you with working with selections. T…

As you probably know, charts (and lots of other visualisations) in Power BI have titles that can be set to any piece of static text. You can do this by selecting the chart, going to the Format tab …

I'm trying to replace an old excel report with a better version using Power BI, but I am having trouble creating a measure that will replicate the results of the old report.    I have two time dimensions to my data - the CPS or Snapshot Date (i.e. when we received the data) and the Pack or Execution...

Good day,    Similar to my earlier post about generational bands. I want to create a retirement date calculation based on certain age bands as a calculated column. I know how to do this in excel, but not in the DAX formulation.    For example, if you were born 1937-1942 your retirement age is 65. So...

This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements. If you read

Hi Xiaoxin Sheng,   Wonrdefull, but this is static, the calculated table is 'created' when loading the data and doesn't change when filtering is applied. But I will give it a try based on your DAX formulas ..

Hi community,   I am quite new in Power BI and DAX. Currently I generated a table that shows in which month, which api has which exception and the total count for that exception. A typical data is like this:    April , user/getresource, SystemException, 4000.    So there are 4 columns, month, api, e...