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...

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.

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...

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…

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

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

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…

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…

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 →

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…

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.

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

, 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

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.

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

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fine, it is fast and reliable and can be updated easily. B

Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals…

Builds off of First Working Day of Week here: https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Working-Day-of-Week/m-p/391332 Provides the same functionality for First/Last Working Day of the Week, Month, Quarter and Year as well as logical true/false tests for these. Included below a...

Suppose you have some data like this: ID DimKey3 DimKey4 DimKey5 DimKey6 1 blue red green green 2 blue blue red blue 3 blue red blue blue 4 green green red green 5 green green blue green 6 red red red red 7 blue blue blue blue 8 green green green green 9 blu...

Similar to Rolling Months, https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499 it is often handy to have the ability to do rolling weeks. For this to work, previous Quick Measures of Week Starting and Week Ending are required. https://community.powerbi.com/t5/Quick-...

"I like big aggregations and I cannot lie You other PBI'ers can't deny" The attached PBIX file contains a slew of aggregations that span multiple columns All standard quick aggregations are included, namely: Max Min Sum Average Count Count (Distinct) Variance Standard Deviation Median This te...

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop. In part 1 of this tutorial, I illustrated how to include more than one aggregation and cu...