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.
Community,
I am a new learner in Power BI. I want to present a card to show a group with highest summarized value. For example, as the data showed below, the sum value of group A is 14, B is 12, C is 12. I want to present number and the group with highest sum value(which here is A 14) in a card. How can I achieve this?
Name | Group | Value |
aa | A | 2 |
ab | A | 3 |
ac | A | 4 |
ad | A | 5 |
af | B | 2 |
dv | B | 1 |
cc | B | 3 |
cd | C | 4 |
ee | C | 8 |
Thanks for the help
Solved! Go to Solution.
Go with this:
Measure =
var TableA= SUMMARIZE('Table','Table'[Group],"Sumbygroup", SUM('Table'[Value]))
Var Maxgroup = MAXX(FILTER(TableA,[Sumbygroup]=MAXX(TableA,[Sumbygroup])),[Group])
Var Maxsum = MAXX(FILTER(TableA,[Sumbygroup]=MAXX(TableA,[Sumbygroup])),[Sumbygroup])
Return CONCATENATE(Maxgroup,Maxsum)
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Go with this:
Measure =
var TableA= SUMMARIZE('Table','Table'[Group],"Sumbygroup", SUM('Table'[Value]))
Var Maxgroup = MAXX(FILTER(TableA,[Sumbygroup]=MAXX(TableA,[Sumbygroup])),[Group])
Var Maxsum = MAXX(FILTER(TableA,[Sumbygroup]=MAXX(TableA,[Sumbygroup])),[Sumbygroup])
Return CONCATENATE(Maxgroup,Maxsum)
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @JcAtHome
Try something like this:
Highest =
VAR __Table =
SUMMARIZE(
'Table',
[Group],
"__Value",SUM('Table'[Value])
)
VAR __Max = MAXX(__Table,[__Value])
RETURN
MAXX(FILTER(__Table,[__Value] = __Max),[Group])
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 |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |