DAX Help

Question

Hi All,&nbsp;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 DE as status for that order but&nbsp; It should display as 1 for all the lines if either of line status is 'DE'&nbsp;Please help.&nbsp;

anonymous · Answer

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.&nbsp;&nbsp;

mahoneypat · Answer

Please try this expression in your measure
&nbsp;
NewMeasure&nbsp;=VAR&nbsp;DErows&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;Table&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;Table&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;Table[Order&nbsp;Number]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table[col_LineItemStatus]&nbsp;=&nbsp;"DE"&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DErows&nbsp;&gt;=&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;
Regards,
Pat
&nbsp;

anonymous · Answer

pmadam&nbsp;This is Solved:Measure = IF(CALCULATE(COUNT(TestData[OrderNumber]), ALLEXCEPT(TestData,TestData[OrderNumber]),TestData[col_LineItemStatus]="DE")&gt;1,1,0)

anonymous · Answer

Replicated it on your Data Too.&nbsp;Measure = IF(CALCULATE(COUNT(TestData[OrderNumber]), ALLEXCEPT(TestData,TestData[OrderNumber]),TestData[col_LineItemStatus]="DE")&gt;1,1,0)

Forum Discussion

DAX Help

4 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX