cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kareus
Frequent Visitor

Formula Help

How can I determine if all the rows that share a particular order # have inventory to ship Order #400001 complete.

 

Report DateOrder #Scheduled DateDescriptionInventoryItems NeededIs Their Enough Inventory On Hand To Ship Order CompleteWHICH ORDER NUMBERS
11/7/202040000011/7/2020Widget #1100025YES 
11/7/202040000111/7/2020Widget #1100020YES 
11/7/202040000111/7/2020Widget #224FALSE 
11/7/202040000111/7/2020Widget #35511YES 
11/7/202040000211/7/2020Widget #35513YES 
1 ACCEPTED SOLUTION
mahoneypat
Super User IV
Super User IV

Here is a column you can put on your orders table to indicate if there is sufficient inventory for each item.  It also works as a measure expression that will work in a table visual with the Order # column.

 

Enough =
IF (
    ISBLANK (
        CALCULATE (
            COUNT ( Orders[Order #] ),
            FILTER (
                ALLEXCEPT (
                    Orders,
                    Orders[Order #]
                ),
                Orders[Inventory] < Orders[Items Needed]
            )
        )
    ),
    "Y",
    "N"
)

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
mahoneypat
Super User IV
Super User IV

Here is a column you can put on your orders table to indicate if there is sufficient inventory for each item.  It also works as a measure expression that will work in a table visual with the Order # column.

 

Enough =
IF (
    ISBLANK (
        CALCULATE (
            COUNT ( Orders[Order #] ),
            FILTER (
                ALLEXCEPT (
                    Orders,
                    Orders[Order #]
                ),
                Orders[Inventory] < Orders[Items Needed]
            )
        )
    ),
    "Y",
    "N"
)

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors