Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SUMX CALCULATION TOTAL

Hello all,   i am new in DAX so i hope you guys can help me out. i want to know how i can get into that amount of 1745 from column name TOTAL OPEN AMOUNT. The TOTAL OPEN AMOUNT is based on the sum ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =CALCULATE(SUM([Open Amount]),ALL(Data[CustomerID]))

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi mattbrice,

 

i am doing this in PowerBI desktop.

 

 

Brianoreilly's avatar
Brianoreilly
Helper II
7 years ago

Any Solution for this?