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/
Hi OZMckenzie ,
I suggest create a calculated table for slicer item and filter it without showing the blank value:
Table 2 = VALUES('Table'[Items])
Then I suggest you use the measure for goal:
Measure =
IF (
ISFILTERED ( 'Table 2'[Items] ),
CALCULATE (
MAX ( 'Table'[Target] ),
FILTER ( 'Table', 'Table'[Items] in DISTINCT('Table 2'[Items] ))
),
CALCULATE ( MAX ( 'Table'[Target] ), ISBLANK ( 'Table'[Items] )||'Table'[Items] = "")
)
Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVKIbloPrEhHoES8kY0d01EBqo5GLRmeE9kN0jewarnT2g?e=A82MD7
Best Regards,
Dedmon Dai
Thank you v-deddai1-msft for your great advice.
I will try it as well.
