KPI card displays different value to card and table - any way to show same value as other visuals?

[po]

Hi,

Noticed in a report where we have the ability to show a range of weeks, that the kpi visual only shows the latest value e.g last week rather than the average as illustrated below.

Looking at some posts, saw some other people have had issues with this. 

Is there a way to enusre kpi card shows same value as other visuals by default rather than just showing last value 

https://community.powerbi.com/t5/Desktop/KPI-Visual-shows-different-value-than-card/td-p/278187

https://community.powerbi.com/t5/Desktop/KPI-card-displays-incorrect-value/m-p/114835#M48410

 

Thanks

[v-lili6-msft · Accepted solution]

HI, @po

After my research, you could create a measure with ALL/ALLEXCEPT Function and use it Indicator Value.

like this:

AVG = AVERAGE(Table1[Qty])

Measure 2 = CALCULATE([AVG],FILTER(ALL(Table1),Table1[Date]<=MAX(Table1[Date])))

Measure 3 = CALCULATE(AVERAGE(Table1[Qty]),ALL(Table1[Date]))

Result:

basic data

Before

After

Best Regards,

Lin

[po]

Thansk for update