Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Not consider duplicate IDs in a Top N

Hi all,   I´m trying to order a similar table in PBI, by sales desc. The thing is that I´d like to discard those companies with the same ID as it´s the case for Accesories and Accesories SL ...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Anonymous ,

    I have assumed that you have an ID column. Please try the following : 

    1. Create a calculated column on your table to give you the min value of company for each ID.

    Min Value =
    CALCULATE(
    MIN(CompSales[Company]),
    ALLEXCEPT(CompSales, CompSales[ID])
    )

     



    2) Using ths table, create a calculated table that has company and sales

    Min Sales =

    SUMMARIZE(
    CompSales,
    CompSales[Min Value],
    CompSales[Sales]
    )

     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 😊

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sure, this would be:

 I´d like to get for example, the min of company column in case the ID is duplicated

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous ,

I have assumed that you have an ID column. Please try the following : 

1. Create a calculated column on your table to give you the min value of company for each ID.

Min Value =
CALCULATE(
MIN(CompSales[Company]),
ALLEXCEPT(CompSales, CompSales[ID])
)

 



2) Using ths table, create a calculated table that has company and sales

Min Sales =

SUMMARIZE(
CompSales,
CompSales[Min Value],
CompSales[Sales]
)

 

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊