Forum Discussion

vaishali12's avatar
vaishali12
Frequent Visitor
7 years ago

Ranking and Count using DAX

Hi,    I'm pretty new to DAX and have been trying to implement the following logic in a visual. The aim to have a rolling window of 7 countries , based on the ranking of a specific country that has...
DAX
vaishali12's avatar
vaishali12
Frequent Visitor
7 years ago

Hi Anonymous , 

 

I apologise for the delay in getting back to you.  I've created a few snapshots of the original table with the snapshots and how the 'To Include' column in the original table changes (with the rules mentioned in the first post as the underlying logic) as the slicer selection changes. 

 

1. Original table with no slicer selection

2. 'To Include' column changes with new slicer selection3. 'To Include' column changes with new slicer selection

Does this seem to make a little more sense?  Thank you very much for your time!

Regards,

shali

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This is still not clear...

 

Where do you get Ranking from? Is this a field in one of your tables? Or is it a measure that adjusts accordingly to the currently visible countries in the column? I'm asking because if it's a column in a table, then it does not look like the rules you've given are going to work. If Ranking is a measure, then...

 

Best would be if you could take a screenshot of your model and paste in here. This would help a lot.

 

Thanks.

 

Best

Darek

  • vaishali12's avatar
    vaishali12
    Frequent Visitor
    7 years ago

    The ranking is a calculated mesaure that I've managed to figure out using DAX, so it's not built into the original table. Only the countries and Airweight are part of the original dataset. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      What happens if two countries happen to have the same value on which you rank? Then your logic will still be valid?

       

      Best

      Darek