Forum Discussion
Solved
Averagex issue
Hello Profis, I am working with a measure called [Durchlauf. in Tagen], which calculates the number of days between different date fields. I attempted to compute an average that includes only va...
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.
Talal141218 Please try with this:
Durchlauf in Tagen =
VAR T =
FILTER (
ADDCOLUMNS (
Fact_SalesLine,
"@val", [Durchlauf. in Tagen]
),
[@val] >= 0
)
RETURN
AVERAGEX (
T[SalesPiklistDate_NK],
[@val]
)I hope this helps. If so please mark it as a solution. Kudos are welcome!
Thanks for your answer, but unfortuntely did't work. I want Average for a Measure "Durch laufzeit in Tagen"
