how to generate rank using total column and group by BU Name and Vendor name

[pokarman]

please find the path for pbix and data file 

https://drive.google.com/open?id=1pMn00iWrOAQMrO4VI1fh1t8fX1bcrzNL

let me know if you have an access

[Anonymous · Accepted solution]

@pokarman Please try below measure and check if it works fo you

Measure = RANKX(FILTER(ALL('Table'[BU Name],'Table'[Vendor Name]),'Table'[BU Name]=MAX('Table'[BU Name])),CALCULATE(SUM('Table'[Total])))

[pokarman]

Thanks @Anonymous 

but still its coming as 1's everywhere