Averagex issue

Hi Talal141218,
Thank you for posting your query in the Microsoft Fabric Community Forum.
I’ve reproduced your scenario in Power BI Desktop using my sample data aligned with your table structure.

To match Excel AVERAGEIF(>=0), I used the following approach:

• Base measure: [Durchlauf. in Tagen] (row-level day difference)

Durchlauf. in Tagen =

VAR PickDate =

    SELECTEDVALUE ( Fact_SalesLine[SalesPicklistDate] )

VAR ShipDate =

    SELECTEDVALUE ( Fact_SalesLine[SalesLineShippingDateRequested] )

RETURN

IF (

    NOT ISBLANK ( PickDate )

        && NOT ISBLANK ( ShipDate ),

    DATEDIFF ( PickDate, ShipDate, DAY )
)

• Final measure: Average_Durchlauf_GE_0, which materializes the row-level values and calculates the average only for values ≥ 0 using AVERAGEX

Average_Durchlauf_GE_0 =

VAR BaseTable =

    ADDCOLUMNS (

        VALUES ( Fact_SalesLine[SalesLineID] ),

        "__Durchlauf", [Durchlauf. in Tagen]

    )

RETURN

AVERAGEX (

    FILTER ( BaseTable, [__Durchlauf] >= 0 ),

    [__Durchlauf]
)

For your reference, I’m attaching the .pbix file so you can review the complete implementation.
Thanks, pcoley & GeraldGEmerick for sharing valuable insights.

Best regards,
Ganesh Singamshetty.