Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

rankx

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.
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , 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]))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , 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]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak 

    I really appreciate your quick and kind response!

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