Forum Discussion

toum's avatar
toum
Icon for Helper II rankHelper II
2 years ago
Solved

Dax total

Hello all,   I need your help on this,I'm working with Power BI DAX and have a table with columns for Key, Amount, and Name. How can I calculate the sum of the Amount for each Key while ignoring re...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    These measures work

    A = MIN(Data[Amount])
    Measure = SUMX(VALUES(Data[Key]),[A])

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

These measures work

A = MIN(Data[Amount])
Measure = SUMX(VALUES(Data[Key]),[A])

Hope this helps.