Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hellgoingon
Helper II
Helper II

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
Dog
Responsive Resident
Responsive Resident

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

View solution in original post

5 REPLIES 5
Dog
Responsive Resident
Responsive Resident

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

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

 

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

Dog
Responsive Resident
Responsive Resident

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. 

 

 

Thanks. Let me try

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.