KPI TARGET IS A MEASURE * FACTOR DOES NOT WORK

[zraopingm]

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

[v-rongtiep-msft]

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.

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.

[zraopingm]

@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

[v-rongtiep-msft · Accepted solution]

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.

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.

[zraopingm]

@some_bih yes, that is a good alternative.

thank you

Zoey

[zraopingm]

@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

[some_bih]

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

[some_bih]

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?