Forum Discussion

Prashant_123's avatar
Prashant_123
Helper I
1 year ago

Power BI Dax Formula

I want to use Rank function so basically I want to rank on basis of Amout the amount which is highest it should be rank 1 but I also want monthwise means if in jan 2024 - 400 - Rank 1, 300- rank 2,,,...
Data Protection
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

HI Prashant_123 ,

Please try the bellow DAX:

Rank Measure = 
RANKX(
    ALL(financials),
    CALCULATE(
        [Sales Amount],
        ALLEXCEPT(financials, financials[Month-Year])
    ),
    ,
    DESC,
    DENSE
)

 

 

Prashant_123's avatar
Prashant_123
Helper I
1 year ago

Hi Bibiano_Geraldo 

 

Failed to resolve name 'financials'. It is not a valid table, variable, or function name.

What is this please be tell me ehat is the option

 

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi Prashant_123 ,

    Replace the table and columns names with your owns.

     

    This financials is not valid for you, because it is in my source data.