Converting measures to dimensions

ezgisonmez — Sat, 16 Nov 2024 19:51:22 GMT

Hello,

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.

Thanks for any helps.

Re: Converting measures to dimensions

berkarmagan — Mon, 21 Oct 2019 14:28:30 GMT

Hi,

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.

topic Converting measures to dimensions in App Development

Converting measures to dimensions

Re: Converting measures to dimensions