No announcements

### measure DAX

Since this forum is dedicated to questions on Power Query and the M language, I'd like to request help from the Mods here so we can move this thread to the Power Pivot / DAX ...
| 3 Replies | 797 Views | Created by Vinicius Aleixo - Sunday, April 15, 2018 10:06 PM | Last reply by willson yuan - Tuesday, April 17, 2018 1:31 AM

### DAX measure error (calculate)

Hi team, I write a dax measure in a data model as following: vs=calculate(sum(tablea[sales],all(tablea[brand group])) What I ...
| 2 Replies | 673 Views | Created by Tom J Sun - Thursday, June 1, 2017 6:31 AM | Last reply by Tom J Sun - Thursday, June 1, 2017 11:36 AM

### conditional sum in powerpivot measure (DAX)

Hello, forgive my ignorance but I'm more of a business guy than IT.  I'd like to create a DAX measure that looks at a text column and if it contains three ...
| 2 Replies | 9581 Views | Created by JohnnyShakes - Monday, November 28, 2011 3:23 PM | Last reply by Challen Fu - Thursday, December 1, 2011 5:36 AM

### dax measure total

cnt = calculate(countrows(table1), table3)
| 2 Replies | 1130 Views | Created by arkiboys - Friday, October 4, 2019 12:33 PM | Last reply by arkiboys - Monday, October 7, 2019 2:28 PM

### DAX Measure for Returning Students?

Hello, I'm trying to create a dax measure that seems to me is a retention problem but without a date/calendar.  See my screenshot below, the top is the raw data, the 2nd is the ...
| 1 Replies | 959 Views | Created by Ryan Smiths - Tuesday, October 28, 2014 12:15 PM | Last reply by Marco Russo - SQLBI - Tuesday, October 28, 2014 2:44 PM

### DAX / Measure - Date Parameters

Another similar DAX measure would be MovingTotal =[TotalSales](DATESBETWEEN(DimDate[FullDateAlternateKey], ...
| 13 Replies | 12892 Views | Created by johncon - Friday, January 8, 2010 7:23 PM | Last reply by johncon - Friday, February 5, 2010 5:50 PM

### Get the 30 previous days in measure DAX (SSAS Tabular)

Hello,     I try to create a measure in DAX that retrun me : The value of previous 30 Days of one measure. For example ...
| 3 Replies | 539 Views | Created by Adghar - Tuesday, February 26, 2019 3:57 PM | Last reply by auaero - Wednesday, February 27, 2019 10:39 PM

### DAX Measure context

this code is translated internally in DAX as following:
| 1 Replies | 1130 Views | Created by ryand09 - Wednesday, June 19, 2019 3:27 PM | Last reply by iamnvt - Saturday, June 22, 2019 9:17 AM

### Help with DAX measure

Hi, The measure you need is quite simple: rate = divide(sum(Data[value]),sum(CroppedHa[area])) I suppose the problem is with fields of the
| 4 Replies | 1060 Views | Created by Igor-M - Monday, January 7, 2019 9:24 PM | Last reply by Aleksei Zhigulin - Wednesday, January 9, 2019 11:30 AM

### DAX Measure filtering on a column in a RELATED table

I am trying to create a DAX measure that returns the last 4 weeks Sales. My powerpivot has a separate calendar table which is linked to the sales table by the ...
| 3 Replies | 22509 Views | Created by barnettjacob - Thursday, January 19, 2012 5:40 AM | Last reply by ruve1k - Monday, January 23, 2012 3:16 PM

### DAX - Measure count active products

I need a DAX measure which shows me the second result:
| 1 Replies | 843 Views | Created by EvertonGomes12 - Monday, August 27, 2018 12:40 PM | Last reply by willson yuan - Tuesday, August 28, 2018 12:38 AM

### DAX Measure Performance

Can someone please explain the performance impact for below expressions: =CALCULATE(SUM('Internet Sales'[Freight]), FILTER('Internet Sales', 'Internet Sales'[DueDate]=MAX('Internet ...
| 1 Replies | 4353 Views | Created by Raunak J - Wednesday, June 20, 2012 5:15 AM | Last reply by Jason Tom Thomas - Thursday, June 21, 2012 5:42 PM

### DAX Measure in Power Pivot

solution, but it Shows the following error message: 'Calculation Error in Measure 'Rating': The expression refers to multiple columns. Multiple columns can not be ...
| 5 Replies | 1034 Views | Created by DAX Measure in Power Pivot - Wednesday, January 31, 2018 11:47 AM | Last reply by Ousama EL HOR - Thursday, February 1, 2018 1:16 PM

### DAX measure to count rows

What is the measure to show the count of rows in Key column for each of the ...
| 5 Replies | 1274 Views | Created by arkiboys - Thursday, October 3, 2019 10:08 AM | Last reply by arkiboys - Friday, October 4, 2019 12:23 PM

### Dax measure - error with total

Please show a sample of your raw data table (not the pivot table). Also, try to explain in your own words (not the formula) what you intend for the measure to ...
| 8 Replies | 5948 Views | Created by silvia.df - Friday, January 13, 2012 10:02 AM | Last reply by ruve1k - Thursday, January 26, 2012 2:11 PM

### Referencing a measure in DAX DATESBTWEEN function

In Powerpivot 2013 I am trying to calculate unit sales per day between the last time an item was received and the last time it was sold, but I keep getting tripped up by the DATESBETWEEN ...
| 1 Replies | 680 Views | Created by rp_m - Monday, February 9, 2015 3:07 PM | Last reply by Imke Feldmann - Monday, February 9, 2015 8:15 PM

### DAX measure: show the latest weeks SalesAmount pr product

table. It is seen as best practice in DAX that you proceed references to a column with the table name and references to a measure with ...
| 2 Replies | 466 Views | Created by axa_oatmeal - Tuesday, December 20, 2016 7:49 AM | Last reply by Angelia Zhang - Wednesday, December 28, 2016 6:01 AM

### Moving Average of a Ratio Measure in DAX

Your CALCULATE() is simply manipulating the context that the measure is evaluated in, not the order of evaluation; you're saying take the rolling 7 day period, and then after having returned ...
| 2 Replies | 1395 Views | Created by NickPPANS - Tuesday, October 21, 2014 9:15 PM | Last reply by NickPPANS - Tuesday, October 21, 2014 10:38 PM