Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two graphics here. The top one is showing an average of all 4 quarters. How do I filter it to only show the latest quarter (Q4 2017)?
Thanks!
=only({<date = {Q4 2017}>}yourMasure)
In this case, you'll need to use Set Analysis.
Take as example the top chart is displaying expression Avg([Sales]) while the bottom chart is displaying Sum([Sales]) by Quarter-Year.
The first one should be modified to Avg({<[Quarter-Year]={''Q4 2017"}>}[Sales]). However, does it make sense to have an average for just 1 value?
Hope the unser provided you some insights. Regards,
It would just be the average of 1 quarter vs 4. Not really 1 value, many values over 1 quarter.
So this would be in the Measure Expression I assume?
Assuming the Quarter is driven off a master calendar and you don't want to have to re-work the KPI each quarter...
Something like:
Avg({<[Quarter-Year]={"=$(MaxString({[Date]=Today()})>} [Quarter-year])"}>} [Sales])