Creation of a specific DAX measure

[Anonymous]

Hi everyone,

I got a table with :

the name of the provider (= column Fournisseur)

the month of delivery (= column Mois Livraison L)

a column for know if the delevery was OK or NOK (= column Conformité). If the delivery is OK it will be write CONFORME and if the delivery is NOK it will be write NON CONFORME

I wanted to create a curve graph with theses informations :

Legend --> name of the provider

X axis --> the month of delivery (= column Mois Livraison L)

Y axis --> the % of compliant deliveries

My problem is for the Y axis. I have to create a measure but i don't know how do it.

For exemple, if my provider "X" have done ten deliverys in January, 8 "CONFORME" and 2 "NON CONFORME", i wanted that the Y axis show the % of compliant deliveries fort the couple provider/month, so 80% for this exemple.

Thansk in advance for your help.

Best regards, Romain

[johnt75 · Accepted solution]

Try

% compliant =
VAR Compliant =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Conformite] = "CONFORME" )
VAR Total =
    COUNTROWS ( 'Table' )
VAR Result =
    DIVIDE ( Compliant, Total )
RETURN
    Result