cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Post Partisan

## If condition issue

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
2 ACCEPTED SOLUTIONS
Super User

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 )``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Community Champion

Hi @akapoor03 ,

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Champion

Hi @akapoor03 ,

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Super User

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 )``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors