No announcements

### DAX formula sum of max

Hi, thanks for the quick answer, but I an not looking for the sum of the columns, but for the sum of the max for each ...
| 8 Replies | 1286 Views | Created by wannes1964 - Friday, May 4, 2018 6:08 PM | Last reply by willson yuan - Monday, May 7, 2018 2:20 AM

### How to get the sum of max

https://social.technet.microsoft.com/Forums/ie/en-US/0ed9b53e-ea46-43df-b92c-808052120953/dax-formula-sum-of-max?forum
| 1 Replies | 450 Views | Created by Sccot_Will - Wednesday, July 18, 2018 10:01 PM | Last reply by willson yuan - Thursday, July 19, 2018 12:54 AM

### Dax Calculating ratios based on multiple conditions

I am new to DAX and need some help to understand if there is a better way to achieve the results I am expecting to get. Requirement: Calculate ...
| 2 Replies | 1146 Views | Created by divkor - Tuesday, March 1, 2016 5:04 PM | Last reply by Ed Price - MSFT - Sunday, October 30, 2016 10:20 AM

### DAX Formula for Running Totals (Student Database)

You don't necessarily need dates, but it makes it easier as the pattern in DAX for a running total relies on getting "years" less than or equal to the ...
| 7 Replies | 877 Views | Created by Darko Giacomini - Thursday, March 22, 2018 7:23 PM | Last reply by Darren Gosbell - Saturday, March 24, 2018 12:08 AM

### PowerPivot DAX formula calculated column running balance

be a SUM of the current row and all previous rows of data, where the actItem is equal.   I am not sure why my DAX ...
| 3 Replies | 3292 Views | Created by Jason A Miller - Monday, August 11, 2014 11:07 PM | Last reply by Jason A Miller - Wednesday, August 13, 2014 6:51 PM

### DAX - SUM of MAX with a Twist

discovered that I had originally written the measure as Distance Traveled:=  SUMX(values('Contract'[VehicleKey]),CALCULATE( MAX([Odometer ...
| 5 Replies | 1313 Views | Created by TheBiConsultant - Wednesday, September 20, 2017 8:25 AM | Last reply by willson yuan - Friday, September 22, 2017 1:24 AM

### DAX Calculated Measure for Sum of Max values

We have a client that wants to take the Max value of a count at the Product level, but then for each Brand (Parent of product), sum the Max values for that ...
| 3 Replies | 12438 Views | Created by Andy Kinnier - Monday, September 21, 2015 1:39 PM | Last reply by Kristin DAX - Thursday, August 25, 2016 2:36 PM

### DAX sum of children

Not at all.. It is correct that the result is simply a sum. But the leaf data are calculated with a formula that cannot be appllied to the aggregated level (cannot ...
| 5 Replies | 1310 Views | Created by Davide Becco - Monday, February 24, 2014 11:41 AM | Last reply by Davide Becco - Monday, February 24, 2014 5:20 PM

### DAX version of the formula

Hi All, Hope you are doing well!..I am new to DAX and trying to convert the following excel version of the formula into DAX...Can you please help ...
| 2 Replies | 841 Views | Created by Hellothere8028 - Wednesday, August 28, 2019 7:58 AM | Last reply by Hellothere8028 - Thursday, August 29, 2019 6:26 AM

### DAX Formula to Calculate YTD Sum by Specific Dates

Hello Everyone, Can some one please help me with a DAX function that can provide sum of sales of this year, let's say from Jan 1, 2015 till ...
| 1 Replies | 746 Views | Created by ANExcel - Monday, October 19, 2015 2:11 PM | Last reply by Ed Price - MSFT - Friday, July 29, 2016 8:38 PM

### Max of Sum ...

, by SUM(Fact[PeopleIn]), let's call this measure [TotalPeople]. Now, your max, min, and average are calculated using MAXX, MINX, and AVERAGEX, respectively. For ...
| 2 Replies | 500 Views | Created by __Erik__ - Friday, July 8, 2016 6:01 PM | Last reply by __Erik__ - Friday, July 8, 2016 7:29 PM

### DAX Sum of children

For example, in the image below, for the account *test* it gives Forecast Error 76450 total, but should return 482152 which is the sum of all the values on the lowest level (entire ...
| 5 Replies | 1877 Views | Created by Jan Van humbeek - Friday, April 11, 2014 1:11 PM | Last reply by Jan Van humbeek - Monday, April 14, 2014 8:13 AM

### DAX formula for % of Emps

; So I have those just fine - my issue is creating the DAX formula to come up with the 40%/60% in my example above.  In a logical way its simple as its The # ...
| 4 Replies | 852 Views | Created by LamdaLamda - Friday, October 14, 2016 5:34 AM | Last reply by Michiel Rozema - NL - Wednesday, October 19, 2016 7:19 AM

### dax formula

how can i make this Dax formula: I need in a product table the last filled result from a checkingtable Checkdate  -  ...
| 2 Replies | 763 Views | Created by Norbertus van der Lei - Monday, March 28, 2016 3:52 PM | Last reply by Charlie Liao - Tuesday, March 29, 2016 6:25 AM

### mdx sum of max

clculataed member              Str_ogr (sum of conctacts)
| 3 Replies | 2102 Views | Created by slawek_z - Thursday, December 4, 2014 1:30 AM | Last reply by Lakmal_Fonseka - Friday, December 5, 2014 3:13 PM

### DAX - DISTINCT SUM Issue

Hi, Try this DAX ...
| 8 Replies | 1378 Views | Created by Jake Burns - Tuesday, August 22, 2017 4:40 PM | Last reply by Ashish Mathur - Friday, September 1, 2017 3:08 AM

### Sum & Max

;10.00  C ID is invoice number VALUE is amount of money  TYPE: sms, letter ...
| 1 Replies | 1930 Views | Created by Karol1997 - Thursday, January 17, 2013 3:25 PM | Last reply by Andrew Sears - T4G - Friday, January 25, 2013 8:29 PM

### Format the DAX Formula

Hi Mahesh,  You will not be able to format the color of your measure in PowerPivot through a DAX ...
| 4 Replies | 5473 Views | Created by maheshrk81 - Thursday, June 21, 2012 1:08 PM | Last reply by Jason Tom Thomas - Thursday, June 21, 2012 5:52 PM