KPI Problem

[Reigning_data]

Hi All,

I'm having trouble making a KPI which indicates 'this weeks sales' agaisnt the target 'average weekly sales'.

While the average weekly sales measure calculates correctly OUTSIDE of the KPI card, when using it within the KPI card, it seems to be filtered to 'this weeks sales' only (resulting in both values being the same).

• WEEK_NUM | SALES
  • 1 | £100
  • 2 | £150
  • 3 | £100
  • 4 | £200
  • 5 | £70

As an example, a KPI card of above should show £70 (goal: £124 (x%) )

Whereas I am getting: £70 (goal: £70 (0%) )

Where am I going wrong? I feel like this is something that should be really simple to fix.

[v-cherch-msft · Accepted solution]

Hi @Reigning_data

You may try to use below measure to get the average weekly sales. KPI get the last values of WEEK_NUM column.

Weekly =
AVERAGEX ( ALL ( Table1 ), Table1[SALES] )

Regards,

Cherie