Text in OLAP Measures
I knew for a long time that measures can have text and not only numbers, but last week I had a scenario where it was the perfect solution for my problem.
Let's say that I work in number of jobs. In every job I got some tasks that I need to do. The fact table looks like this: