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
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