Why don't use session variable assigned to Role. Or you can try using Indexcol function as well. Check below link if it helps!!!
Thanks for your reply. If you read above I did mention that I plan to use INDEXCOL, but what I am not sure about is how to handle the scenario where report needs to show 5 measure and and trying to use same report when we need to show different number of measures. Because these measures are different columns in these reports.
And I don't want empty columns showing up in the report