Forum Discussion
Ranking and Count using DAX
Yeah... it's all good and can be done but... what is it that you want to calculate? Is it, for instance, for each country the average of AirWeight over the countries that you want to pick up through the rules?
Best
Darek
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!
@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
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
