Hello everyone! I am trying to compute SUM of TOP N values in a table in a time period specified via slicers using following measures: 1. VolumeSum = CALCULATE(SUM(Volumes[Volume]); Volumes[Dimension]="mln l") 2. VolumeRanks2 = RANKX(ALL(Producers[Producer Eng]); CALCULATE(SUM(Volumes[Volume]); ...

We Want to Flag Rows in our Companies Table (on left) When TheyContain a Keyword from our MatchList Table (on right) These are a few of my favorite

Hi See the attached file. Hope it helps Here are the steps Step#1 Determine the First and Last Years with Actual data using these MEASURES FirstYear = FIRSTNONBLANK ( ALL ( YearTable[Year] ), CALCULATE ( SUM ( MeasureTable[Revenue] ) ) ) LastYear = LASTNONBLANK ( ALL ( YearTable...

Please try this as a caluculated column Is 2nd Tuesday = VAR a = 'Dates'[Date] VAR y = FILTER( ALL(Dates[Date]), YEAR('Dates'[Date]) = YEAR(a) && MONTH('Dates'[Date]) = MONTH(a) && DAY([Date]) 7 && DAY([Date]) 15 && WEEKDAY([Date],3) = 1) RE...

Hello everyone, I'm new in DAX and I have a big problem with a measure (sorry my bad english). I need to calculate the average of Distinctcount for 7 days moving, for that, I'm counting distincts rows every day like that Vehiculos Totales:=DISTINCTCOUNT(VEHICULOS[PATENTE]) Second, I need to do ...

Thanks very much for your timely assistance, ! Works like a charm! thank you.. thank you.. thank you

Hi , you're going in the right direction - the signal growth = today's value - previous day's value The previous day's row could be thought of as having the maximum timestamp that's less than today's timestamp. There is probably a more elegant way to express this idea, but this is how I'd do it ...

Currently, Power BI does not have a built-in feature that enables you to switch between hierarchy le...

Dear all, I’m new in power BI and I have a problem for calculating a weighted average based on a total of a column. In attach a simplified example for my PBIX. As you can see I have two table, a master table and a summarize table, with few fields calculated from master table. On summarized table I h...

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could caus

Use stats functions in Power BI to calculate the daily average sales for any given date range.

I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE f...

During a conversation at PASS Summit, one of the developers of Power BI shown me a way to use TREATAS...

The Dynamic RLS topic is getting a good response in my blog post, so I intend to write about other types of scenarios that a security would be required. In this post, we are going to look at another t…

bring the awesome to moving averages with text formulas for slicer and title— and yes, a Greatest Formula In the World (GFITW) version for custom calendars

I have written while ago, about how to implement a dynamic row level security in Power BI. This post is an addition to that post. I’ve had a lot of inquiries that; “What If I want users to see their o…

We show you how to use a KPI or card as a slicer.

Confused about a Power BI Term? Check out our Dictionary.

There is a new DAX function coming soon to Power BI Desktop: COMBINEVALUES. It concatenates an unlimited number of values with a delimiter. You can already use the function by connecting to a dataset …

Workaround for some missing basic Power BI functionality: Right aligning text and dealing with mixed number formats within one column.

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Colu…

Level: Intermediate Background I was reading the questions at http://community.powerbi.com today and saw an interesting question. In short the OP wanted to know if there was a way to identify (via a m…

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis. I've created many videos over at Enterprise DNA TV which showcase these techn…

The Challenge At a recent Columbus Azure ML and Power BI User Group (CAMLPUG) meeting, a member came forward with the following problem around tracking training attendance. Essentially, given a set of…

This article introduces a technique to filter and productively compare two time periods with Power BI. Time intelligence calculations are among the most re

A few years ago I wrote this post on how to alias columns in a table in DAX, using a combination of AddColumns() and Summarize(). The good news is that in Excel 2016/the Power BI Designer/SSAS Tabular…

I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want…

I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain the rows that have data in the fact table. That way t…