Grouping items with totals

[vnicholl]

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 depts and the groups, so I would have 01234A would be $8 (3 + 5), 01236B would be $9 (4+5) and then 2000 would be $7 (3 + 4) and 2060 and 4000 would be $5 each. 

How can I do that in Power BI desktop?

[Ashish_Mathur]

Hi,

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

Measure = sum(Data[Money])

Hope this helps.

[smpa01 · Accepted solution]

@vnicholl  you need two measures

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

[vnicholl]

Thanks! I am trying both of these.

[smpa01]

@vnicholl  did you try the above?