KPI to reflect total from table that has visual level filters

[AnAnalyst]

I am trying to have my KPI show the same values as the table on my dashboard. I have filters on the second visual below.

Example Files

Version 0 is Actuals/Plan - The others are Forecast versions. I would like to be able to toggle between forcast versions (will always have version 0 selected)

[v-juanli-msft · Accepted solution]

Hi @AnAnalyst 

Create a measure

Measure =
CALCULATE (
    [FY Fcst vs FY Plan],
    FILTER (
        ALLSELECTED ( Sheet1[Project] ),
        [Fcst vs Plan] < 0
            && [FY Fcst vs FY Plan] > 0
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnAnalyst]

Thank you!