Forum Discussion
Show highest values for each category
Hi, let's say I have the following data: Category Team Value A 1 5 B 2 10 C 3 15 D 1 20 A 2 5 B 3 0 C 1 15 D 2 10 For each team I want to show the ...
On the measure? That's not possible in Power BI. Or I can use TOPN for category or team but that does not seem to work.
Hi Anonymous ,
According to your statement, I think in Team2, B and D should both be the category with highest value.
Measure:
Category with highest value in each Team =
VAR _Step1 =
FILTER (
ADDCOLUMNS (
'Table',
"Sum each Category", CALCULATE ( MAX ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Team] ) )
),
[Value] = [Sum each Category]
)
RETURN
CONCATENATEX ( _Step1, [Category], "," )Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Hi there. This is a good solution, however I need the SUM of "Value" which is the highest for each category. Not the single value of "Value" which is the highest. Do you understand?
Anonymous Hi there, do you have a new solution? Because I think your solution was in a good direction.