rankx

[taimaizumi]

Hi, every one!

I' like to use 'Rankx' correctly but I can't show the visual as I expected.

Below is detailed

<table structure>

<to realize>

to add rank of sum_shipment by category1 and date

<I tried>

input dax as below

------------------------------------------------------------

calculate(RANKX(ALL('Dimension_002_Calender'[Date]),'Measure_001_出荷'[sum_shipment]),all('Dimension_003_Category'[category1]))

------------------------------------------------------------

I think above dax can reset the implicit filter by category1 and date, but it didn't work.

[taimaizumi]

@amitchandak 

I really appreciate your quick and kind response!

By doing what you adviesed, it worked well as I'd like to do!

[amitchandak · Accepted solution]

@taimaizumi , use the fact table which is the source for the measure in place of the fact 

calculate(RANKX(Summarize(ALL(Fact), 'Dimension_002_Calender'[Date],'Dimension_003_Category'[category1]),'Measure_001_出荷'[sum_shipment]))