Forum Discussion

uie79957's avatar
uie79957
Regular Visitor
4 years ago

KPI Visual Values - Actual Month, Target Year

Hi all,   I am stuck with following situation: I have little measure which calculates a yearly budget value in % - which works just fine. Target Visualization: The actual values for each month ar...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

uie79957 ,

You need to have measure like

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

 

 

assuming the target is also joined to the date table

Also, refer

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400