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

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])