Problem with a measure

[Milozebre]

Hello,

I have a question about a measure. I have this picture 'picture1).

I get "Engagement Ok and KO" in a SQL query that says if the escalation level is greater than 3 then this is Ok

I would like to be able to make the percentage of commitments in relation to the total

Example for ISIE Service: Ok 92.79% and KO 7.21%

When I do this: MEASURE SLA = CALCULATE (COUNT ('Folders Clos' [RespectCommitment]);         FILTER (ALLSELECTED ('Closed Folders'); 'Folders Closed' [RespectCommon] = "ENGAGEMENT OK") ) / COUNT ('Closed Folders' [RespectCommission])

I get this (picture2)

Can you help me ?

Thank you

[Milozebre]

Hello InterKoubess, 

First, thank you for your response and its working.

I modify (in my case) because withe the SQL request you didn't have, the COUNT function is more suitable. 

the measure like this : 

Pourcentage =
VAR Nbr =
CALCULATE ( COUNT ( 'Dossiers Clos'[RespectEngagement] ); ALL ('Dossiers Clos'[RespectEngagement]) )
RETURN
DIVIDE ( COUNT ( 'Dossiers Clos'[RespectEngagement] ); Nbr; BLANK () )

A big thank you for your help.

[Interkoubess · Accepted solution]

Hi @Milozebre,

I recreated your sample data and I don<t hve the same percentge for example for ISIE-Retail (65/1033=6,30% and 968/1033=93.7%).

Anyway I created this measure below and it seems to work for me ( check the printscreen as well):

Pourcen =
VAR Nbr =
    CALCULATE ( SUM ( Data[Nombre] ), ALL ( Data[Engagement] ) )
RETURN
    DIVIDE ( SUM ( Data[Nombre] ), Nbr, BLANK () )

If it does not work or if you have any observations please let us know.

Ninter