Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Redundand values

Hello community, How do I aggregate all the values that are not top 10 of sum values as 'other'? Many thanks,
Need Help
  • Elena_Kalina's avatar
    Elena_Kalina
    1 year ago

    Hi Anonymous 

    Please try this one:

     

    Product Grouping =
    VAR CurrentCategory = SELECTEDVALUE('Superstore'[Product Name])
    VAR Top10Categories =
        CALCULATETABLE(
            TOPN(
                10,
                VALUES('Superstore'[Product Name]),
                [Total_Sales],  
                DESC
            ),
            ALLSELECTED('Superstore'[Product Name])
        )
    RETURN
        IF(
            CurrentCategory IN Top10Categories,
            [Total_Sales],
            "Other"
        )
     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi Tatiana-Weiss,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution, as this will help other members with similar queries.

Thank you.