Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
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]))
Thanks! I am trying both of these.
@vnicholl did you try the above?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |