Forum Discussion

dombarg's avatar
dombarg
Icon for Helper II rankHelper II
8 years ago

problem in Rank Dax -need small modification

hello.i want to rank my city based on their sales. i've write following dax and it seems ok rankx = RANKX(ALLEXCEPT(Table1,Table1[Region],Table1[Year]),[sales],,DESC) it is ok in table.but i need ...
Need Help
dombarg's avatar
dombarg
Icon for Helper II rankHelper II
8 years ago

bar chart in picture is what i need,expect for the number of city code.

in bar chart in picture  we want to show only 803 which is max.indeed,i want to how only max of city in each region in barh chart.