Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart that is showing total people served on an annual basis (Year is the Dimension, Client Count is my Measure) and then I have a second dimension stacked with the first to show the number of people served by County. I am wanting to create a KPI for each county that will show the average number of people served in each County based on the year/years selected. Anyone have thoughts of how to build the KPI?
Try this
=Avg(Aggr(Sum([Client Count]), Year, County))
For specific country
=Avg(
Aggr(
Sum({<County={'india'}>} [Client Count]),
Year
)
)
Thank you. I'm trying the second one to make each KPI correlate to a specific county. Here's what's I'm entering in my expression:
avg(aggr(sum({<[Client.County]={'Barber'}>}[Client Count]), Year))
When I exit the editor the KPI is drawing no results. Any thoughts?