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!
Solved! Go to Solution.
Total = calculate(sum(Table[Value]), allselected())
Total = calculate(sum(Table[Value]), allselected())
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!