Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
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
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
69 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |