problem in Rank Dax -need small modification

Question

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 to show only Max and Min of (city in respect to their) Rank in Bar chart axis.so I have:

max of rank = maxx('Table1',[sales])

the problem is that both of city appeared on bar char axis.

I've attached sample Dashboard and following pictures.

thank u

here is Dashboard Download link

anonymous · Answer

dombarg,Please check the modified PBIX file.https://1drv.ms/u/s!AhsotbnGu1NokzQJzGzRT-TTrL7-Regards,Lydia

anonymous · Answer

dombarg,Could you please post expected result in a table format or bar chart?Regards,Lydia

dombarg · Answer

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.

dombarg · Answer

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 changedindedd,i need to show both max and min in axis bar.

dombarg · Answer

is there any way to calculate min of each group??

Forum Discussion

problem in Rank Dax -need small modification

6 Replies

Related content

Logic problem?

Fetch the File modification time

Slider problems

Problems in UK South

FILTERING PROBLEM