Forum Discussion

alexbalazsalex's avatar
alexbalazsalex
Helper IV
8 years ago
Solved

Rankx or Topn

Dear All ,   i would need you support to retrive my top customers   I have the following table   Year month product details Client Tons 18-Jan aa 11 5 18-Jan v 2 4 18-Jan ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi alexbalazsalex,

     

    Was my above suggestion helpful to you? If yes, would you please kindly mark it as an answer so that it can benefit more users?

     

    Thanks,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi alexbalazsalex,

 

Please try below measures:

Total tons =
CALCULATE (
    SUM ( Client_Tons[Tons] ),
    ALLEXCEPT ( Client_Tons, Client_Tons[Year month], Client_Tons[Client] )
)

Rankx =
RANKX (
    ALLEXCEPT ( Client_Tons, Client_Tons[Year month] ),
    Client_Tons[Total tons],
    ,
    DESC,
    DENSE
)

Insert a table visual and drag corresponding fields to it. If you want to show TopN records, please add [RANKX] into "visual level filters" and set its value to be equal to or less than N.

 

Best regards,

Yuliana Gu

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi alexbalazsalex,

     

    Was my above suggestion helpful to you? If yes, would you please kindly mark it as an answer so that it can benefit more users?

     

    Thanks,

    Yuliana Gu