No announcements

### How to calculate incremental sums with DAX?

when you are trying to calculate regarding a numerical or a datetime field In your example, the order of strings "Monday", "Tuesday"... is not ...
| 1 Replies | 7191 Views | Created by Afelino - Thursday, December 2, 2010 5:46 PM | Last reply by Mei-kang Wu - Friday, December 3, 2010 9:45 PM

### DAX - Calculate New Customer

Hi All, I'm new in the dax world. I need to calculate the number of new customers of 2014 in my FactInvoice ...
| 3 Replies | 2641 Views | Created by AlessandroGG - Friday, June 13, 2014 10:51 AM | Last reply by Marco Russo - SQLBI - Saturday, June 28, 2014 3:50 PM

### DAX Calculate with 2 dates

Thank you for answering ... I need to calculate value and filter date today between two dates like ...
| 5 Replies | 1236 Views | Created by fit9 - Monday, January 16, 2017 1:19 PM | Last reply by Michiel Rozema - NL - Wednesday, February 1, 2017 11:26 AM

### DAX CALCULATE filter Order

>>Can someone explain, why I’m getting a slightly result with the two functions? What is the rule on how I should filter with Calculate
| 2 Replies | 917 Views | Created by ryand09 - Wednesday, June 20, 2018 8:06 PM | Last reply by ryand09 - Thursday, June 21, 2018 8:04 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 | 658 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

### DAX: CALCULATE on SUMMARIZE with named column ?

hi all, I have a SUMMARIZE over a group of columns, with a *named column* for a particular calculation for a set of values, that works great.  I would like to ...
| 2 Replies | 1358 Views | Created by Cos2008 - Tuesday, February 18, 2014 9:28 PM | Last reply by Charlie Liao - Thursday, February 20, 2014 1:29 AM

### DAX Calculate Upper and Lower Control Limits

You can calculate the mean (or average) and Standard deviation using builtin functions. But for upper and lower control limits, you must make your own calculations in dax. This is ...
| 3 Replies | 12479 Views | Created by RenatoFreitas - Friday, December 21, 2012 12:26 PM | Last reply by RenatoFreitas - Wednesday, December 26, 2012 5:16 PM

### How to calculate pivot-like subtotals using DAX

. What I am looking for is a DAX formula to create that colum with subtotals in the personnel table. Hope I have made my ...
| 6 Replies | 10709 Views | Created by kirvis - Monday, March 5, 2012 9:21 AM | Last reply by kirvis - Wednesday, March 14, 2012 5:09 PM

### PowerPivot - How to use DAX calculate function (dynamic segmenation)

Hello, I am trying to build up a formula by using DAX functions to be able to cluster values (\$0-\$1000, \$1000-50000, etc.) using some ...
| 1 Replies | 549 Views | Created by Petr Sk - Thursday, September 8, 2016 6:50 AM | Last reply by Angelia Zhang - Friday, September 9, 2016 11:14 AM

### Calculate trimmed mean in DAX mean

you, then you can include this in a FILTER() Within the CALCULATE() to remove outliers. If you can describe the logic you need, I can help with the measures.GNet Group BI ...
| 2 Replies | 3206 Views | Created by Maracles - Wednesday, November 4, 2015 11:56 AM | Last reply by greggyb - Thursday, November 5, 2015 5:10 PM

### DAX to calculate SUM of distinct Ids

Hi Aniruddha,  You could try to use below query to see whether it works or ...
| 4 Replies | 1000 Views | Created by Aniruddha Thengadi - Monday, June 24, 2019 2:12 PM | Last reply by Aniruddha Thengadi - Wednesday, June 26, 2019 9:16 AM

### DAX - Calculate based on current row value

Just trying to learn DAX so apologies if the answer to this question  Would like to calculate a Count based on a column value per ...
| 2 Replies | 5361 Views | Created by Ramon Ber - Thursday, September 25, 2014 9:11 AM | Last reply by Ramon Ber - Thursday, September 25, 2014 3:32 PM

### How to calculate RowNumber of a row in DAX

Hello, I have a requirement to find the rowmumbers based on a group. I know there is Rownumber function in sql. How can I implement the same in DAX. PFA ...
| 5 Replies | 19488 Views | Created by MSBIBeginner - Monday, April 20, 2015 10:17 AM | Last reply by Imke Feldmann - Thursday, April 23, 2015 8:09 PM

### SSRS 2008 custom code to properly calculate sums

calculations to determine which 2 counts are the closest, however, I'm stuck on baby-step #1 in that I can't get data to persist. Meaning I can't even get the correct ...
| 7 Replies | 7291 Views | Created by gr8fasushi - Wednesday, May 29, 2013 8:45 PM | Last reply by Charlie Liao - Monday, June 3, 2013 2:07 AM

### DAX: Cannot calculate decimal values

in your example/screenshot you have created the calculation as "calculated measure" and not as KPI there is a seperated tab/button to create KPIs - ...
| 6 Replies | 3799 Views | Created by the_txeriff - Monday, January 14, 2013 2:40 PM | Last reply by the_txeriff - Monday, September 16, 2013 7:11 AM

### DAX CALCULATE and ignore slicer selections?

example above with the _test measure  - to no avail. sum_adj_sentiment_es:
| 3 Replies | 32554 Views | Created by almaplayera - Thursday, August 29, 2013 8:41 PM | Last reply by blezin - Tuesday, February 14, 2017 6:36 PM

### DAX query to calculate previous week to current week

previous week first. Please see my sample DAX below: previous = CALCULATE(max(tab[currentweek]), (FILTER(ALL(tab),tab[Weeknumber]=MAX
| 1 Replies | 2725 Views | Created by Gugan.t - Monday, January 16, 2017 7:36 PM | Last reply by willson yuan - Wednesday, January 18, 2017 1:45 AM

### Calculate sum of product using DAX

Hi Everyone, Can anyone help me to create DAX formula for getting contribution numbers as per below image. Please see below explanation of each ...
| 2 Replies | 568 Views | Created by ManikantM - Wednesday, November 9, 2016 10:34 PM | Last reply by ManikantM - Saturday, November 12, 2016 10:24 AM