Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |