Forum Discussion
Use same measure over different data sets
I have data set A and B, both have the same metrics (Profit) but are at different levels of granularity (Day/Hour). I have created a new measure in set A for cumulative profit and I use it in a line chart.
I wanted to create another chart on a seperate page with the same metric on set B but I get an error saying the measure already exists.
Is there any way to link the source of a measure to a page or visualisation, I created a bunch of new measure for set A and they all apply to set B so it would be good to be able to use them.
Thanks in advance
2 Replies
Hi Quantisport ,
This isn't something that would normally be done. As you say yourself, the two datasets essentially show different things so you would generally need to create new measures for your second dataset. You could theoretically do it with some significant DAX gymnastics, but it would be quicker to just create the new measures.
I'd say there's two simple options:
1) Copy and paste the calculation text of each of your original measures into new ones, but just change the table/column names to your second data source.
2) If your two datasets indeed show exactly the same data just at different granularities, then run the whole report from the lowest (i.e. hourly) granularity data then just roll it up into days/weeks/months etc. as required.
Pete
HI Quantisport
I agree with BA_Pete, The way I would impletement BA_Pete 's idea is by using
and
Once, you get familiar with the tabular editor, life becomes very easy with creating measures.
Install link - https://github.com/otykier/TabularEditor/releases/tag/2.11.7
Its way simpler and very fast copying and pasting same measure over different datasets.
It also comes with lot of other feature with you will find Here
