Forum Discussion

swong's avatar
swong
Icon for Helper II rankHelper II
9 years ago
Solved

Average over time vs. sliced average

Hi,   I'm hoping to use PowerBI to show overall market trends as well as trends in individual accounts. My data has several different slicers, e.g. location, device type, etc.   Is is possible fo...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

swong's avatar
swong
Icon for Helper II rankHelper II
9 years ago

Thanks 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's avatar
swong
Icon for Helper II rankHelper II
9 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Try:

    AllMeasure = CALCULATE(
	SUM('RevenueTable'[Revenue]),
	ALL('RevenueTable')
)

SomeMeasure = SUM('RevenueTable'[Revenue])