Split measures table

[RafaelAri]

I have a measures table, with lots of measures.
In principle, there are 3 subjects in the table, so I would like to split it to 3 different tables.
Is it possible, after creating the tables, to copy measures from the original table to the new ones?

[Uzi2019 · Accepted solution]

Hi @RafaelAri 
can you share the data with example like input and expected output?

[johnyip · Accepted solution]

@RafaelAri, I think relocating the existing measures to the new measure tables is what you are looking for.
You can do that as follows:

Or alternatively, you can assign a display folder on the measures. This will also help in grouping different measures in different directories, serving the same purpose of measure table.

If, however, what you want to do is really creating copies of measures to the new measure table, you should only be able to achieve that by creating new measures that have the exact definition of the original measures.

And reading from your words, I would recommend you to use "display folder" in the one measure table you already have. This allows you to group different measures under diferent fodlers under the same measure table, which should be clear enough for your working.

[RafaelAri]

Thanks ✔️ got it

[Uzi2019 · Accepted solution]

Hi @RafaelAri 
can you share the data with example like input and expected output?