Summarize or Group By with multiple conditions?

spencer_II Right, so would need much more information to be able to provide a solution for this but I have done similar stuff and it's fun stuff to work on. If you can provide more information I might be able to take a look. 

Order Fulfillment - Microsoft Fabric Community

Delivery Dates - Microsoft Fabric Community

 

Love the supply chain stuff. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Hi, spencer_II 

If you want to group or summarize your data, you can use the SUMMARIZE function. In this function, you can select the column you want to group or summarize. You can also use the calculate and filter functions together to implement multi-condition filtering. data and group them. I created the following sample data:

I created a new table and used the SUMMARIZE function to summarize the above data and filter the data with the smallest Exp dt:

 

Table 2 =
CALCULATETABLE (
    SUMMARIZE (
        'Table',
        'Table'[item number],
        'Table'[Lot number],
        "Date", CALCULATE ( MIN ( 'Table'[Exp dt] ), FILTER ( 'Table', 'Table'[Exp dt] ) )
    )
)

 

In your description, for 101550 items, I think it may be because Trs dt is empty, so the corresponding behavior of sum of Trans qty bU/M is empty. You can override a measure to calculate Trans qty bU/M instead of using the default sum aggregation function directly. If you can make a sample pbix file or data that does not contain private data, it will help you solve the problem faster. You can click the link below to learn how to use summarize:

SUMMARIZE - DAX Guide

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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