Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago

Dynamic RankX

Can you help me with the Mesures .T1 and .T2 in the following example?   https://drive.google.com/open?id=1QpXYl5U9-2K_5Ex5eSyPLkhnjCF6S5Vb   The goal is to Rank the both visuals in page 2   Th...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Fcoatis,

 

I'm a little confused about your scenario. Please describe your requirement in more details.

 The explanation is below the link. I would like to use RankX in both visuals of page 2. 


You have three visuals in Page 2. If I understand your scenario correctly that you want to use T2 measure in table visual in Page 2 and rank the measure [.Max Last n Days] dynamically based on the slicer?

 

If it is convenient, please share your desire output so that we could help furher on it.

 

Best Regards,

Cherry

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago

Hi Cherry,

 

The scenario is: Given an interval of dates I can choose a period of days to show the best and worst periods of sales. This is achieved in page 1. I´m trying to use Rankx in both tables of page 2 to show this results:

 

 

Obviously, it must be dynamic, once the tables increase depending on the date interval and period selected.Let me know if you need further details.

 

Thanks

 

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Fcoatis,

     

    Sorry for the delay.

     

    By my research of your pbix, I have a little confused about your scenario.

     

     

    Based on the image above, I have confused about your measure .Max Last n Days.

     

    From my understand, the measure should return the last n days based on the max date from your date slicer? 

     

    You could see that max date in the date slicer is 2015/5/11 and the sales table has the sales value on 2015/5/11, but your measure return the max date is 2015/4/20.

     

    Could you please check if your measure .Max Last n Days is correct. 

     

    If I misunderstood something, please describe your logic in more details.

     

    Best  Regards,

    Cherry