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