Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table with the following type of data
Customer | Value |
A | 10 |
B | 20 |
C | 15 |
A | 10 |
B | 21 |
B | 15 |
I want to display a table in Power BI which just displays the max value for each customer, eg
Customer | Value |
A | 10 |
C | 15 |
B | 21 |
I then need another measure which totals the max (to display in a card), so that value in the above example would be 46.
Can anyone help with the dax measures please?
Solved! Go to Solution.
Max w Total =
SUMX (
VALUES ( Ben[Customer] ),
CALCULATE ( MAX ( Ben[Value] ) )
)
Max w Total =
SUMX (
VALUES ( Ben[Customer] ),
CALCULATE ( MAX ( Ben[Value] ) )
)
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |