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 would want to create a column 'To include' where it will be 1 if it fits the rules, or 0 if it doesn't. 

This column would be used to filer out the countries that are to be shown on a visual (a bar chart for example) which ranks the countries with 'to Include' = 1 based on the Air Weight. 

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
7 years ago
@vaishali12 wrote:

Hi @darlove , 

 

I would want to create a column 'To include' where it will be 1 if it fits the rules, or 0 if it doesn't. 

Where do you want to create the column? I still don't understand... Would you please create some picture of what it really is you want and paste in here? You can draw on a piece of paper (but legibly!), take a pic with your phone and post here... That'll be the fastest way.

 

Best

Darek