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?
Solved! Go to Solution.
@vnicholl you need two measures
byDept = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[dept]))
bygroup = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[group]))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
Hi,
Depending upon which fields you drag to the visual, a SUM measure should work
Measure = sum(Data[Money])
Hope this helps.
@vnicholl you need two measures
byDept = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[dept]))
bygroup = CALCULATE(SUM('Table'[money]),ALLEXCEPT('Table','Table'[group]))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
Thanks! I am trying both of these.
@vnicholl did you try the above?
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
180 | |
96 | |
79 | |
77 | |
74 |