Forum Discussion
Solved
Dynamic target
Hello, Looking for great advice here... I'd like to set up dynamic target to a KPI card, the target value list as below. In Biz Unit "B", 3 items are further divided respectively. The column o...
For year and the business unit it should work. so we need handle item
New measure like
if(isfiltered(Table[Items]), sum(table[Target]),calculate(sum(table[Target]),isblank(Table[Items])))
Refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
For year and the business unit it should work. so we need handle item
New measure like
if(isfiltered(Table[Items]), sum(table[Target]),calculate(sum(table[Target]),isblank(Table[Items])))
Refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
This is very helpful, thank you very much! amitchandak