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 all,
New to Power BI and struggling with something probably quite easy. I have imported data from an excel as follows:
User | Amount | Group |
A | 10 | 1 |
B | 12 | 1 |
C | 14 | 2 |
C | 12 | 2 |
B | 22 | 1 |
A | 234 | 1 |
D | 24 | 2 |
D | 2 | 2 |
C | 7 | 1 |
But looing to create a chart visual as follows:
User | Amount | Group | Group Total |
A | 10 | 1 | 285 |
B | 12 | 1 | 285 |
C | 14 | 2 | 52 |
C | 12 | 2 | 52 |
B | 22 | 1 | 285 |
A | 234 | 1 | 285 |
D | 24 | 2 | 52 |
D | 2 | 2 | 52 |
C | 7 | 1 | 285 |
Not sure what to search for but appreciate any help.
Thanks
Solved! Go to Solution.
OK, I literally spent 10 times longer looking for that post rather than just doing this:
Measure =
VAR __Group = MAX('Table'[Group])
RETURN
SUMX(FILTER(ALL('Table'),'Table'[Group] = __Group),'Table'[Amount])
PBIX is attached. Sorry, next time instead of trying to refer you to a similar issue, I'll just solve the thing! 🙂 PBIX is attached below.
Hi @NiugeS ,
Please try this:
Measure =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( ALL ( 'Table' ), 'Table'[Group] = MAX ( 'Table'[Group] ) )
)
If you also need to show the total value, please try this:
Total Measure = SUMX('Table',[Measure])
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks - just downloaded the pbix file from the other post and trying to work it out. Thanks.
Thanks @Greg_Deckler - i can't say I follow .. sorry, new to Dax but trying to figure it out. Not sure if negative numbers are causing issues either but will try and figrue it out.. thank you
OK, I literally spent 10 times longer looking for that post rather than just doing this:
Measure =
VAR __Group = MAX('Table'[Group])
RETURN
SUMX(FILTER(ALL('Table'),'Table'[Group] = __Group),'Table'[Amount])
PBIX is attached. Sorry, next time instead of trying to refer you to a similar issue, I'll just solve the thing! 🙂 PBIX is attached below.
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |