dax

How do you optimize a DAX expression? In this session, Alberto Ferrari analyzes some DAX expressions and Tabular models and, through the usage of DAX Studio

This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel.

, Please check if the following DAX returns your expected result. If not, please share sample data of your table and post your desired result. Measure = COUNTROWS(FILTER(ZeroTFSlLevel,ZeroTFSLevel[PlaceOrPte]="Pte"&&ZeroTFSlLevel[Enrol_count] = 0)) Regards, Lydia

Hi , This is what I was talking about : https://drive.google.com/file/d/1NK1xeEJT8tE1KmBEPXY2l8GeAsxWTVHG/view?usp=sharing Hope it helps... Ninter

In this tip we show how you can calculate employee attrition rates. You can apply these methods in Power BI Desktop, Analysis Services Tabular or Azure Analysis Services.

Introduction This is the latest post in my series "Fun with Graphing in Power BI". It might be my last as well. There are a few different reasons for that. First, and most importantly, I believe I may…

Yesterday I was working on a data set, and needed to work out the Top x with Ties in Power Query. This posed to be a bit more challenging than I first thought it would be. Why did I want … Continue reading →

What I am doing with the DAX below is to only show the concatenation of values if a value is filtered. If nothing is filtered (Selected) then display text to show that nothing has been selected, ot…

I had a requirement where my customer was looking to gain some insights into their data relating to reactivated players. The definition used for a reactivated player is a player that has previously…

In the latest weeks I received several requests to support a different color for variable names in DAX Formatter, just as the formula editor available in Po

A recurring issue for Power BI users writing DAX code is that column filter removal might have an unexpected behavior when the Sort by Column is active on t

Power BI offers the ability to create Groups and Bins to help consolidate data into a more presentable or meaningful visualization. You can also recreate a lot of what you would typically do in the UI…

While it would be a bit presumptuous to presume that any single formula could account for all possible measure total situations, the following pattern is presented for handling matrix measure values as well as subtotals and grand totals. This pattern has the added flexibility of being able to handle...

In this post you learn how to leverage DMVs to get SSAS Tabular and Power BI Model object dependencies. It is easy to find DAX Measures dependencies, calculated column dependencies and much more. I made a tool in Power BI which is available for you to download for free.

Hi , You can add a new column: Count Per Id_Page into category = var c1=CALCULATE(COUNT(Table2[IdPage]),FILTER('Table2','Table2'[IdPage]=EARLIER(Table2[IdPage]))) return IF('Table2'[Index]=CALCULATE(MAX('Table2'[Index]),FILTER('Table2','Table2'[IdPage]=EARLIER('Table2'[IdPage])&& Table2[IdCatego...

Hey guys!! You might have seen my previous post about adding working days. This is still part of the same problem, however, I've established a method that I need help writing the correct code for. Assuming my date table looks like this: (May 9th is a holiday for example purposes) Date Wo...

Obviously T-SQL and DAX are two different query languages and it serves entirely different purposes.However, as a person who came from database development background , when I learn DAX initially, …

Published on May 13, 2018: In this video, we will learn about 1. The background of people who learn DAX and why they encounter difficulty 2. What concept tak...

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated i

Disconnected Slicers With DAX Variables & SELECTEDVALUES Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots. So this post will be in moving picture

One of the relatively new functions for Analysis Services Tabular, Power Pivot and Power BI is TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where this function can be useful.

If you have a fiscal year starting in March, you can have a problem using the time intelligence functions in DAX. For example, by using February 28, the fis

In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX […]