Forum Discussion

vnicholl's avatar
vnicholl
Icon for Helper II rankHelper II
4 years ago
Solved

Grouping items with totals

Hi,   I have data that is something like this (dept, group, money coming in columns): 01234A, 2000, $3 01234A, 2060, $5 01236B, 2000, $4 01236B, 4000, $5.   I want to group the totals for the...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    vnicholl  you need two measures

    byDept = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[dept]))
bygroup = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[group]))

     

     

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

Hi,

Depending upon which fields you drag to the visual, a SUM measure should work

Measure = sum(Data[Money])

Hope this helps.