How to refer to a column in measure.

[SelflearningBi]

OTIF Quantity % =

divide(CALCULATE(SUM('FW22_5 25'[Confirmed Quantity(Total)]),'FW22_5 25'[OTIF]="Yes"),SUM('FW22_5 25'[Confirmed Quantity(Total)]))

I have this function.  Since ther are empyt value in OTIF column. I would like my confirmed quantity exclused those sum of OTIF missing value. 

How should l

[v-kkf-msft]

Hi @SelflearningBi ,

I am not sure if I understood your question correctly. Your measure [OTIF Quantity %] formula is correct, if you want to convert the calculated column [OTIF] to a measure, please use the MAX or SELECTEDVALUE function.

OTIF =
IF (
    ISBLANK ( MAX ( 'FW22_5 25'[on Time] ) ),
    BLANK (),
    IF (
        AND (
            MAX ( 'FW22_5 25'[In Full] ) = "Yes",
            MAX ( 'FW22_5 25'[on Time] ) = "Yes"
        ),
        "Yes",
        "No"
    )
)

If you want to calculate the percentage of the total value of the values listed as "Yes" in the [OTIF] column, try the following formula.

OTIF Quantity % = 
DIVIDE (
    CALCULATE (
        SUM ( 'FW22_5 25'[Confirmed Quantity(Total)] ),
        'FW22_5 25'[OTIF] = "Yes"
    ),
    SUMX ( ALL ( 'FW22_5 25' ), 'FW22_5 25'[Confirmed Quantity(Total)] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.