I have a project which have dataflow from many different data sources. I need to create a data model, calculate 27 different KPIs and 7 domains consisting of these 27KPIs. Each KPI may be loaded from different sources. I think to calculate these calculations in load editor. Actually there is no problem doing them. My problem is to be able to create a dimension that I have created these calculations as measure. I mean, I have 27 different calculations as measure, but also I need a field which includes the names of these 27 calculations. In the attachment, you can find the screen shot that I want to get.
I'm not sure that i totally understood the question but, i think you calculate all the measures and put them in one table right?
You can use inline table, put 2 columns, one for key to your table which you have measures, and one for names. Than you can use this column for dimension.
