No announcements

### Behave a group Total as an attribute DAX

Goal: create group total as an attribute using Tabular/DAX Scenario:  we have: ...
| 3 Replies | 572 Views | Created by b_blase - Tuesday, November 29, 2016 10:26 AM | Last reply by Herbert Seidenberg - Thursday, December 1, 2016 12:41 AM

### dax measure total

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

### Running total dax

Thanks, but it doesn't work. I created a sequence number column on the table, simple  row_number() over (order by TRA.TRXDate) AS ...
| 13 Replies | 1294 Views | Created by astridaku - Friday, July 12, 2019 3:03 PM | Last reply by astridaku - Monday, July 22, 2019 2:05 PM

### SSRS group total and grand total of group total issue

#DataScope http://stackoverflow.com/questions/11730073/grand-total-value-doesnt-match-with-top-n-filtered-values-in-ssrs ...
| 1 Replies | 32 Views | Created by Anonymous - Tuesday, August 14, 2012 10:38 AM | Last reply by Anonymous - Tuesday, August 14, 2012 11:47 AM

### Running Total in DAX Problem

http://www.thebiccountant.com/2016/12/01/analyzing-events-with-a-duration-in-dax-further-simplification/ Imke Feldmann TheBIccountant.com
| 3 Replies | 908 Views | Created by RonInOttawa - Thursday, December 8, 2016 4:33 PM | Last reply by Imke Feldmann - Tuesday, December 13, 2016 8:55 AM

### How the DAX query behave in SQL

Hi Sweta, If you mean to use SQL statements to express the logic of the DAX query above, the SQL statement could be written like this. SELECT SUM(T
| 3 Replies | 723 Views | Created by Sweta Chauhan - Wednesday, July 17, 2019 10:24 AM | Last reply by Will_Kong - Thursday, July 18, 2019 8:41 AM

### SSRS Total of a Group

On the line labeled "Total" I'm trying to get a total of the group but I keep getting the total of the entire dataset not what actually ...
| 1 Replies | 2916 Views | Created by dam2522 - Wednesday, October 26, 2011 2:58 PM | Last reply by Elvis Long - Monday, October 31, 2011 1:32 AM

### Calculate total from group total

are overtime or under. Is there a was to sum all the totals from each group? I need to group by week first to caculate the week overtime and then see the ...
| 2 Replies | 6847 Views | Created by PeterPsa - Thursday, July 8, 2010 7:51 AM | Last reply by PeterPsa - Monday, July 19, 2010 7:06 AM

### Serialize a class as an xml attribute?

Class B is part of class A (exposed as a public property).  When class A is serialized, the property of type B needs to be serialized as an ...
| 3 Replies | 3211 Views | Created by J-- - Friday, February 8, 2008 9:13 PM | Last reply by Nathan Anderson - MSFT - Tuesday, February 19, 2008 12:09 AM

### Display Group total and grand total

I need to display row counts for group and total.  What is the bes way to do this?  I have a group called "unit"  that needs to display ...
| 1 Replies | 4829 Views | Created by jschroeder - Monday, March 21, 2011 11:19 PM | Last reply by Samuel Vanga - Tuesday, March 22, 2011 3:02 AM

### COMMULATIVE TOTAL USING DAX FORMULAS

For each year I have the montlhy sales as per table below and I want to calculate the commulative total from Jan 2012 to Feb ...
| 4 Replies | 938 Views | Created by C.Panteli - Saturday, January 31, 2015 6:00 PM | Last reply by C.Panteli - Sunday, February 1, 2015 9:45 PM

### Unexpected Group Row Total

also add total before or after for a row group or a column group. In the tablix data region row or column group area, right-click a cell ...
| 3 Replies | 650 Views | Created by beeyule - Monday, August 17, 2015 4:16 PM | Last reply by Qiuyun Yu - Tuesday, August 18, 2015 2:26 AM

### Dax measure - error with total

Hi, thanks for your interesting on my problem. Here below, you can find a data sample and the sintax of my formula (as on my first ...
| 8 Replies | 5952 Views | Created by silvia.df - Friday, January 13, 2012 10:02 AM | Last reply by ruve1k - Thursday, January 26, 2012 2:11 PM

### Total Items in a Group

make up variable names (TimeCount) "on the fly" as part of an SQL Statement and use it in a record set.  I guess that makes sense since you have to ...
| 2 Replies | 26 Views | Created by Anonymous - Friday, September 18, 2015 5:27 PM | Last reply by Anonymous - Monday, September 21, 2015 4:19 PM

### DAX Group By Question

solution, please kindly mark it as an answer. By doing so, it will benefit all community members who are facing this similar issue. Your contribution is highly appreciated.Best
| 2 Replies | 937 Views | Created by ryand09 - Thursday, June 7, 2018 8:23 PM | Last reply by willson yuan - Thursday, June 21, 2018 5:59 AM

### matrix group total label

was to utilize the same column inside an expression written within the header of total column to show values as Q1,Q2 etc Otherwise you've to write ...
| 4 Replies | 617 Views | Created by Aniruddha Thengadi - Tuesday, November 27, 2018 5:48 AM | Last reply by Aniruddha Thengadi - Tuesday, November 27, 2018 8:32 AM

### Custom sum total of a single group

Can any one solve this... I created a group and placed a file called sum(amount). The group is returning Two values Say - ...
| 1 Replies | 4940 Views | Created by VishalR - Sunday, March 12, 2006 7:05 AM | Last reply by VishalR - Friday, March 17, 2006 1:56 PM

### % of Parent Total whit Dax Expressions

https://blog.westmonroepartners.com/favorite-quick-easy-dax-calculate-percent-of-total-scenario/ If this is not what you want, please elaborate the issue and ...
| 10 Replies | 3011 Views | Created by Edwin Valbuena - Friday, February 26, 2016 10:03 PM | Last reply by Edwin Valbuena - Wednesday, March 2, 2016 7:39 PM