KPI Indicator help

[Miskondukt]

I am trying to get the KPI to work as I hope it is able to. The screenshot below shows both the KPI and the data for it and as you can see it is only measuring the last month's value, how can I get it to cumulatively measure?

This screenshot is of the setup and I have it to count (Distinct), but when I measure against my data it is also adding one extra...

What might I be doing wrong on the setup?

Thank you much

[v-ljerr-msft]

Hi @Miskondukt,

Have you tried the solution provided above? Does it work in your scenario? If the solution works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here.

Regards

[Miskondukt]

bumpity bump

[GilbertQ · Accepted solution]

Hi @Miskondukt

Can you possibly create measures for your values, and then use the measures in the corresponding KPI fields?

Another option is to try out some of the other Custom KPI visuals which do give you more options for the KPI?

https://store.office.com/en-us/appshome.aspx?productgroup=PowerBI