Show total on all rows with DAX

[Anonymous]

Hi there,

For our case we need to have a DAX measure that shows the total of a value on all rows. This needs to in dynamically so we figured that DAX should be needed.

Here is an example:

	Value	Total
a	1	11 --> SUM(A:C)
b	4	11
c	6	11
TOTAL	11	33

Does anyone know the DAX measure for this?

Thanks!

[amitchandak · Accepted solution]

@Anonymous ,

Total = calculate(sum(Table[Value]), allselected())