SUM TOTAL KPI'S

[a-santiago]

HI!

I'm trying to rewrite the next formula in order to be able to SUM the totals of the different KPIS of my table, not to retrieve the last value.
*** I do need to retrieve the value for the last date of each year cause otherwise, I'll have duplicates. But in the end, I want the total to sum the result of each year:

Here is an example of how I calculate the Tier 1:

CALCULATE( SUM(SNAP[KPI_VALUE])

            ,FILTER(SNAP,SNAP[KPI_ID]=110)

            ,FILTER(

                ALL(SNAP[YTD_MONTH]), SNAP[YTD_MONTH]=MAX(SNAP[YTD_MONTH]))

)+0)

Thanks!

Filter the last date of every year  @amitchandak 

[amitchandak · Accepted solution]

@a-santiago , checkout closingbalanceyear and lastnonblankvalue

Power BI closingbalancemonth closingbalancequarter closingbalanceyear, lastnonblankvalue- Closing Balance, Distribute Target: https://youtu.be/yPQ9UV37LOU

or

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...