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

pmadam 

This is Solved:

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