DAX Formula Needed

[sciartilli]

looking for a DAX formula in Power Pivot that will get me the YELLOW highlighted data. I basically want the GRAND total of the account number to show no matter how many other metrics I pull into the table. So when I bring the state in it breaks the account amount up by state but I also want to see grand total

 

[arunsjain]

Hi

Try this.

=
CALCULATE (
SUM ( 'Table'[Amount] ),
ALL ( 'Table'[Location of account] )
)

 

[arunsjain]

Or Try following if you are adding more column in it
=
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLEXCEPT (
'Table',
'Table'[Account]
)
)