Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

add RANKX to current dax measure

Hi Experts

 

have a little trouble in added rankx to the current measure...so the 1/7/2019 is value 1 and the oldest date 36..

Table 2 = ADDCOLUMNS(FILTER(CALENDAR(MIN(PMS_FINANCIAL_PDS[Month Start]),MAX(PMS_FINANCIAL_PDS[Month Start])),DAY([Date]) =1),
        "CountComplaints", CALCULATE(COUNTA(PMS_COMPLAINT[MATERIAL_ID]),
            FILTER(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start].[Year] = YEAR(EARLIER([Date]))
                && PMS_FINANCIAL_PDS[Month Start].[MonthNo] = MONTH(EARLIER([Date]))))+0)
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Xiaoxin Sheng

    I have managed to solve the problem using the following DAX and Amend my orginial DAX formula. Much Appericated for all the support you guy provide.

    Index = 
RANKX(
    PMS_FINANCIAL_PDS,
    PMS_FINANCIAL_PDS[Month Start],,,
    Dense
)

4 Replies

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

        Sorry for late response, I try to access your link but it seems expired. Can you please renew and share it?
        Regards,

        Xiaoxin Sheng