SUM TOTAL KPI'S

Question

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])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,FILTER(SNAP,SNAP[KPI_ID]=110)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL(SNAP[YTD_MONTH]), SNAP[YTD_MONTH]=MAX(SNAP[YTD_MONTH])))+0)&nbsp;Thanks!Filter the last date of every year&nbsp;&nbsp;amitchandak&nbsp;

amitchandak · Accepted Answer

Anonymous , checkout closingbalanceyear and lastnonblankvalue 
Power BI closingbalancemonth closingbalancequarter closingbalanceyear, lastnonblankvalue- Closing Balance, Distribute Target: https://youtu.be/yPQ9UV37LOU
&nbsp;
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-f1c839ee884e

Forum Discussion

SUM TOTAL KPI'S

1 Reply

Related content

Ranking KPI card

PowerBI Wrong Total Sum

Calculate Total - Wrong Total Sum

Wrong Total sum

PowerBI Wrong Total Sum calculation