Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
5 years ago

DAX Help

Hi All,   I am trying to create a measure to show as 1 if either of the line item status is 'DE' for that order number. I created on measure but its displaying as 1 only for that line number with ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is how I did it on my data set. COuld you please share your DAX query and sample data file. I can replicate the code for you.

 

 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Please try this expression in your measure

 

NewMeasure =
VAR DErows =
    CALCULATE (
        COUNTROWS ( Table ),
        ALL ( Table ),
        VALUES ( Table[Order Number] ),
        Table[col_LineItemStatus] = "DE"
    )
RETURN
    IF (
        DErows >= 1,
        1,
        0
    )

 

Regards,

Pat