Forum Discussion
Function ALL does not work if the column is sorted by another column.
Hi Binkhorst ,
You can and you must use the Month Name on your reports on your measure you must use the MonthNumber.
The calculations in measures is based on context so if you pickup a column from a table, in this case Month Name, all the other columns in the same row are pickup based on context also so the Month Name is pick up for your visualizaiton and by the row context the month number is pickup and used in your measure so everything will work properly.
There is no need to use only the columns you use on your measure in the visualization the context transcition make it work properly.
Thank you for your input. That would mean I cannot use MonthName in my reports and I hoped there would be another solution.
Super UserHi Binkhorst ,
You can and you must use the Month Name on your reports on your measure you must use the MonthNumber.
The calculations in measures is based on context so if you pickup a column from a table, in this case Month Name, all the other columns in the same row are pickup based on context also so the Month Name is pick up for your visualizaiton and by the row context the month number is pickup and used in your measure so everything will work properly.
There is no need to use only the columns you use on your measure in the visualization the context transcition make it work properly.