Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic RANK on contract and monthly level not working

Hello Everyone,   I'm quite new to PoweBI. I've been reading posts here and trying many things to get a rank to work which I could get done in the back end with SQL rank and partition but I need to...
RANKX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Do you have any column in visual that do not below to table R_TEST  and not aggregated , if so rank will inside that column . Also, add calculate on distinctcount and check

PBI RANK =
RANKX (
FILTER ( ALL ( R_TEST )
,R_TEST[IsFinished] = 1 && R_TEST[IsFinished] = 1
)
,calculate(DISTINCTCOUNT(R_TEST[CONTRACT_ID])) --R_TEST[OVERALL_SORT]
,--1/0
,ASC
,Skip --Dense
)

 

For Rank Refer these links, if Needed
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak Yes all fields are in the same table, including the rank measure. I tried DISTINCTCOUNT but it didn't work. I'm not sure using DISTINCTCOUNT on CONTRACT_ID is what I need as I need to rank the CONTRACt IDs by ModifDate, not the unique values!