cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hellgoingon Member
Member

KPI - display total number insteaad of newest number?

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dog Established Member
Established Member

Re: KPI - display total number insteaad of newest number?

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

5 REPLIES 5
Dog Established Member
Established Member

Re: KPI - display total number insteaad of newest number?

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

hellgoingon Member
Member

Re: KPI - display total number insteaad of newest number?

Thanks. Let me try

hellgoingon Member
Member

Re: KPI - display total number insteaad of newest number?

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

Dog Established Member
Established Member

Re: KPI - display total number insteaad of newest number?

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. 

 

 

Highlighted
lfrigione Regular Visitor
Regular Visitor

Re: KPI - display total number insteaad of newest number?

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

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 216 members 2,583 guests
Please welcome our newest community members: