I'm not sure if this is bug or by design but the native KPI visual is only displaying the latest value of a measure given. For example if you have table: Label Value Date A 13 ...
sqlchicken
Microsoft Employee
8 years agoAh that totally explains it, thank you! Once I rewrote the measure it displayed expected number. I was expecting the KPI to display the average based on the whole but I see with a straight AVERAGE(col) without the CALCULATE context, it was doing it per row and only displaying latest. Thanks.