Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
My data looks something like this :
Folder No | Order # | Amount |
300 | 10024 | $500 |
300 | 10025 | $500 |
300 | 10026 | $500 |
301 | 10032 | $20 |
301 | 10033 | $20 |
|
When I make a table it ends up adding all the $500s for Folder 300 to make my total $1500. The total I want is actually $500 because order 10024+10025+10026 =500.
For 301, the total i want is $20, but it adds both up to make it $40
I tried using distinct or average, it throws off the totals of the table and just averages EVERYTHING.
Any tips?
Thanks!
Anyway to add a new columns that will make my data look like this
Solved! Go to Solution.
@PBINewbie920 measure
Measure2 =
SUMX (
GROUPBY (
_tbl1,
_tbl1[Folder No],
"sum", MAXX ( CURRENTGROUP (), _tbl1[Amount] )
),
[sum]
)
How about this?
SUMX (
VALUES ( Table1[Folder No] ),
CALCULATE ( MAX ( Table1[Amount] ) )
)
@PBINewbie920 measure
Measure2 =
SUMX (
GROUPBY (
_tbl1,
_tbl1[Folder No],
"sum", MAXX ( CURRENTGROUP (), _tbl1[Amount] )
),
[sum]
)
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |