Forum Discussion
Helper IIAverage over time vs. sliced average
Hi swong,
I have reviewed your shared pbix file. And I find that there is no problem with the formula of the measures. Instead of using Date hierarchies as Axis, you should use the Date column itself as Axis, then it will work as expected. :smileyhappy:
Here is the modified pbix file for your reference. :smileyhappy:
Regards
You could but you'll need to get tricky. I can think of a few ways to achieve this, so i'll offer one method and if that isn't suitable i can suggest other ideas.
You'll need a single measure that shows everything on the market, using an ALL or ALLEXCEPT depending on what filters you want to constrain this with (i.e. maybe a date range).
Next, you'll need a measure that does the same as the previous, just without the ALL/ALLEXCEPT. Now, put both those measures onto your line graph.
One issue you might face however, is that doing this you are going to have a shared Y-Axis. This means unless you are using a function that normalizes data in some way, you might not be able to get much value out of the smaller line. For example "SUM" data will be more problematic compared to data such as % growth.
swongThanks for the response!
I'm still fairly new to PowerBI, so I'm not sure what you mean.
I would create a new measure showing my average revenue for everything? How would I include the AL or ALLEXCEPT? Woud I be able to affect both measures with different filters?
- swong
I tried making some new
measure = ALL('RevenueTable'[Revenue])
but the measure can't be loaded: A table of multiple values was supplied where a single value was expected.
Try:
AllMeasure = CALCULATE( SUM('RevenueTable'[Revenue]), ALL('RevenueTable') ) SomeMeasure = SUM('RevenueTable'[Revenue])