Forum Discussion
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 ...
dombarg,
Please check the modified PBIX file.
https://1drv.ms/u/s!AhsotbnGu1NokzQJzGzRT-TTrL7-
Regards,
Lydia
thank u .it is very nice and cool an simplebut there is still a problem.
when i change maxx with minx,it doesn't work and the result wont changed
indedd,i need to show both max and min in axis bar.