Get % of specific value found in measure

[StuartSmith]

I have the measure...

Country KPI Met Icon = IF([Country KPI] >= 0.99, "Expected KPI Met",

IF([Country KPI] >= 0.95 && [Country KPI] < 0.99, "Minimum KPI Met", "KPI Breached"))

and trying to create another measure to display in a card visual, that will give the % of values that contain "KPI Met".

I have tried a few things, but cant figure it out.  Thanks in advance.

[Anonymous]

%met = 
let kpi_met = CALCULATE( COUNT( [Country KPI]), [Country KPI] >= 0.99)
let kpi_total = COUNT( [Country KPI])

RETURN
DIVIDE (

     kpi_met,
     kpi_total

)

[StuartSmith · Accepted solution]

Sorry, i should have put that "Country KPI" was also a measure, so the above solution would not work.  I was then able to find a solution here: Solved: Count rows with measure equal to x - Microsoft Fabric Community

Thanks for replying and Kudos given 👊

[Anonymous]

Glad you got it sorted!