Forum Discussion
Show highest values for each category
pratyashasamal If I use this one, I get for every category the highest value of sum. That is not what I want. I need for each team only 1 category, not all of them with the highest values. How can I do that?
Memorable MemberTry TOPN function once
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 ZhouIf 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?