KPI - display total number insteaad of newest number?

[hellgoingon]

Hi all,

I have below data:

Month            Total new customers

1/2017             10

2/2017              15

3/2017              5

When using KPI control, 5 is displayed. Can i display 30 instead of 5? I need this because i must keep cool-trends in the background of KPI. But i do not want to display 5, i want to display 30.

How can i do that?

[Dog · Accepted solution]

Hi @hellgoingon

If you are looking for the total you will need to add a measure that aggregates the "total new customers"

TotalCustomers:=Sum('Table1'[Total new Customers])

just change the name of table1 to your table. 

then link the measure to the KPI visual. 

Dog

[lfrigione]

I have the same problem but this solution doesn't work

[hellgoingon]

@Dog: It does not work. After doing this, it is still 5

[Dog]

do you have anything on the report page that is applying a filter. If so but you still need to display the full total regardless of filters you can edit the measure or create two to keep it simple. 

CountofCustomers:=Sum('Table1'[Total new customers])

another measure 

TotalCustomers:=CALCULATE([CountofCustomers], ALL('Table1'))

this should prevent any filtering on table 1 (your table) to amend the results. 

[hellgoingon]

Thanks. Let me try