How to sum the subcategory and show in the category?

[weezzy_Z]

Hi, I have order number for each branch, I would like to know the average accurate timediff between ESD and ATD time. So I need to have a sum of subcategory(order) timediff and show in the branch timediff. And further use the sum 47074 divided by 3(we have 3 order have timediff). Please enlighten me, thanks!!

[v-cgao-msft · Accepted solution]

Hi @weezzy_Z ,

Please try this measure:

DEP TimeDiff = 
IF (
    ISINSCOPE ( 'Table'[ColumnName] ),
    ABS (
        DATEDIFF ( [Lastest estimated DEP for port], [Actual DEP for port], MINUTE )
    ),
    AVERAGEX (
        DISTINCT ( 'Table'[ColumnName] ),
        ABS (
            DATEDIFF ( [Lastest estimated DEP for port], [Actual DEP for port], MINUTE )
        )
    )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data