Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

pratyashasamal Hi, thanks for your reply! This solution only looks at the maxium value of 'value'? Because I need the category where the SUM of value is the highest for each team.

pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Anonymous ,
You can use TOPN function to get the highest sum of sales value by category.
For example :-

EVALUATE
    TOPN (
        1,
        ADDCOLUMNS (
            VALUES ( 'Product'[Product Category] ),
            "@Sales Amount", [Sales Amount]
        ),
        [@Sales Amount],
        DESC
    )
ORDER BY [@Sales Amount] DESC
Example 2 :-
TopN 2nd example = 
TOPN(
    2,
    VALUES(DimProduct[Category]),
    CALCULATE(SUM(FactInternetSales[SalesAmount]))
)


You can refer to this link :-
https://dax.guide/topn/
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C