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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Replicated it on your Data Too.

     

    Measure = IF(CALCULATE(COUNT(TestData[OrderNumber]), ALLEXCEPT(TestData,TestData[OrderNumber]),TestData[col_LineItemStatus]="DE")>1,1,0)