Measure for KPI

[Anonymous]

I have a requirement where i need to show the value of Target when all SU is selected and then filter the target value by SU.

that is for january if all SU is selected then the target should be 94.40% and when AAO is selected it should show 94.30 and so on.

Please find the attached table,

A help is needed ,Do i need to create a measure or column?

[amitchandak]

@Anonymous ,

Not sure, to you need Avg Target Try

averagex(allselected(Table),Sum(Table[Target]))

[Anonymous]

Hello Amit i created another post and explained it briefly with some more screenshot.
https://community.powerbi.com/t5/Desktop/KPI-calculated-measure/m-p/1060508#M495480

[v-xuding-msft]

Hi @Anonymous ,

Maybe you could try like this:

Measure =
VAR SBU =
    ALLSELECTED ( 'Table 2'[SBU] )
VAR CountSelectedValue =
    COUNTROWS ( SBU )
VAR Target =
    CALCULATE ( SUM ( 'Table'[Target] ), FILTER ( 'Table', 'Table'[SBU] IN SBU ) )
VAR Default =
    CALCULATE ( SUM ( 'Table'[Target] ), 'Table'[SBU] = BLANK () )
RETURN
    IF ( CountSelectedValue = 12, Default, Target )

 

You could reference the blog of similar topic.

Slicer with AND condition in Power BI 

Please download my sample to learn more details.

[parry2k]

@Anonymous not sure what you mean when all SU selected then filter the target by SU, can you elaborate?

[Anonymous]

I am sorry it's SBU not SU