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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
zraopingm
Helper III
Helper III

KPI TARGET IS A MEASURE * FACTOR DOES NOT WORK

Hello, 

I have a measure FY24sales total = calculate(sum(sales), year="2024"), say $100

Another measure FY25sales total=calculate(sum(sales), year="202"), say $150

3rd measure target = FY24sales total*1.1, 

when i create a kpi, my target does not work, it shows as 0,

but if i manually create a measure target = $110, it will work.

Can someone explain why? 

Many thanks

Zoey

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @zraopingm ,

A KPI visual requires a base measure that evaluates to a value, a target measure or value, and a threshold or goal.

If you don't think this is the visual object you want, you can try using card.

vrongtiepmsft_0-1716254543571.png

vrongtiepmsft_1-1716254566065.png

Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

 

If I have misunderstood your meaning, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @some_bih ,

Thanks for your quick response.

Hi @zraopingm ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

vrongtiepmsft_0-1716184214313.png

It works well, please make sure you put the year field in the trend axis.

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

@some_bih 

hi Rongtie,

thank you for taking the extra steps! this means a lot.

If i used the date table field say "year" into the tread axis, it works.. but if i used the time from the trans table where the sum of data resides in, it wont work.. is this normal? 

In other words, do we have to use date table fields for KPI?

 

Zoey

Anonymous
Not applicable

Hi @zraopingm ,

A KPI visual requires a base measure that evaluates to a value, a target measure or value, and a threshold or goal.

If you don't think this is the visual object you want, you can try using card.

vrongtiepmsft_0-1716254543571.png

vrongtiepmsft_1-1716254566065.png

Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

 

If I have misunderstood your meaning, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

@some_bih yes, that is a good alternative.

thank you

Zoey

zraopingm
Helper III
Helper III

@some_bih 

SORRY that is my typo when i posted the help message, it shouled be "2025"

the measure works fine. 

let me repost my needed help below: 

I have a measure FY24sales total = calculate(sum(sales), year="2024"), say $100

Another measure FY25sales total=calculate(sum(sales), year="2025"), say $150

3rd measure target = FY24sales total*1.1, 

when i create a kpi, my target does not work, it shows as 0,

but if i manually create a measure target = $110, it will work.

Can someone explain why? 

Many thanks

Zoey

Hi @zraopingm based on your posts, it is not clear hou you use these measures, like matrix with/ without slicer....





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






some_bih
Super User
Super User

Hi @zraopingm 

Check red part of your measure

Another measure FY25sales total=calculate(sum(sales), year="202"), say $150

it could be typo as you only wrote 202, not 2025?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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