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
uie79957's avatar
uie79957
Regular Visitor
4 years ago

amitchandak Thank you very much, that worked very well! But considering only on year. I also have a year slicer. How I have to modify the Code whenI need to filter for different Years, but not for months?? E.g. the target values for 2021,2023 etc. are diffrent, but within the year they stay the same.

 

This is how it's looking right now:

 

 

NQC Budget % = 
VAR ManufacturingCosts = CALCULATE(SUM(NQC_controlling_budget[MC [k€]]]),filter(ALL('Calendar'),'Calendar'[Date].[Year]=MAX('Calendar'[Date].[Year])))
VAR Budget = CALCULATE(SUM(Budget_NQC[NQC [k€]]]),filter(ALL('Calendar'),'Calendar'[Date].[Jahr]=MAX('Calendar'[Date].[Year])))
RETURN
DIVIDE(Budget,ManufacturingCosts,0)