Forum Discussion

Krystyna's avatar
Krystyna
Regular Visitor
3 years ago
Solved

Rankx for every year

Hello Krystyna here I am new in PowerBi world and I need some help with a RANKX function. My data has only three columns: ProductId, Year, Value I need to rank products for every year. I created ...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Krystyna ,

     

    Based on your description, I have created a simple sample:

    Please try:

    Measure =
RANKX(ALLEXCEPT('Table','Table'[Year]),CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Year]),[ID]=EARLIER('Table'[ID]))),SUM('Table'[Value]),,Dense)

    Output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Krystyna's avatar
Krystyna
Regular Visitor
3 years ago

Results:

 

Many doubled ranks when value is completely different

Thennarasu_R's avatar
Thennarasu_R
Icon for Responsive Resident rankResponsive Resident
3 years ago

Krystyna 
Rewrite Dax  Inside the ALL Functions Change column  to  Table 

Thanks,
thennarasu