If condition issue

[learner03]

How can write a DAX for below to get desired result in Result whole order fulfil column-

So, if for an order no., 'can fulfil' column is same for all items, then 1 otherwise 0 if even one item in that order is having 0 on can fulfil column. So, 1 will indicate that whole order can go together otherwise can't.

	order no.	item	can fulfil	Result whole order fufil
	A	123	1	1
	A	345	1	1
	B	345	1	0
	B	123	0	0
	C	456	0	0
	C	789	1	0
	C	234	0	0
	D	456	1	1
	E	287	0	0
	E	123	0	0
	F	356	0	0

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood correctly your question, because I am confused about order number E and F.

However, please check the below picture and the attached pbix file. It shows the same result as yours.

Result whole order fulfil CC = 
VAR currentorderno = Data[order no.]
VAR filtertable =
    FILTER ( Data, Data[order no.] = currentorderno && Data[can fulfil] <> 1 )
RETURN
    IF ( COUNTROWS ( filtertable ) > 0, 0, 1 )

[Samarth_18 · Accepted solution]

Hi @learner03 ,

You can also try this:-

Result whole order fufil = 
var result = COUNTROWS(FILTER('Table','Table'[order no.] = EARLIER('Table'[order no.]) && 'Table'[can fulfil] = 0))
return IF(ISBLANK(result),1,0)

output:-

Thanks,

Samarth

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood correctly your question, because I am confused about order number E and F.

However, please check the below picture and the attached pbix file. It shows the same result as yours.

Result whole order fulfil CC = 
VAR currentorderno = Data[order no.]
VAR filtertable =
    FILTER ( Data, Data[order no.] = currentorderno && Data[can fulfil] <> 1 )
RETURN
    IF ( COUNTROWS ( filtertable ) > 0, 0, 1 )