cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 2
Highlighted
Super User I
Super User I

Re: Use same measure over different data sets

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

Highlighted
Community Champion
Community Champion

Re: Use same measure over different data sets

HI @Quantisport 

I agree with @BA_Pete, The way I would impletement @BA_Pete 's idea is by using

pranit828_0-1598118317926.png

and 

pranit828_1-1598118338175.png

 

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 

 


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors