Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |