Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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)
Solved! Go to 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 ) )
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 ) )
Thank you!