Forum Discussion
Solved
Function ALL does not work if the column is sorted by another column.
I have a fact table and a date table. In the date table I have a column for the MonthName. This is a tekst column so I have sorted it by the MonthNumber column to correctly order the months. I ...
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, that works perfectly.