4 Replies Latest reply: Jan 29, 2018 5:58 PM by David Forest

# How to filter KPI to only one quarter of data?

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!

• ###### Re: How to filter KPI to only one quarter of data?

=only({<date = {Q4 2017}>}yourMasure)

• ###### Re: How to filter KPI to only one quarter of data?

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,

• ###### Re: How to filter KPI to only one quarter of data?

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?

• ###### Re: How to filter KPI to only one quarter of data?

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