Incorrect KPI Measure Total

[bw70316]

It appears that instead of summing the totality of my data set, my KPI is defaulting to the HIGHEST TOTAL WITHIN MY DATA SET and displaying that. Is it possible for KPI's to default to the total amount of all the data and still have dynamic abilities? It works fine individually, but I'd like to have a Total measure similar to the guage in the top picture?

[v-yulgu-msft · Accepted solution]

Hi @bw70316,

Please create a measure similar to below and add it to KPI.

Total =
CALCULATE ( SUM ( table[Value] ), ALLSELECTED ( table ) )

Best regards,

Yuliana Gu

[munchkin666]

@v-yulgu-msft  it works for me, thank you!

[Anonymous]

Hi, Thank you! It works but I've just lose the trend axis in that way... any idea?

Thank you!