https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-simple-average/m-p/3092897#M108410 <P>This is an example of my data and current output:<BR /><BR /></P> <P><img /></P> <P>BoNummer is a unique key.<BR /><BR />My current measure is this:</P> <LI-CODE lang="markup">Time from creation to death in Years = CALCULATE ( VAR TestamentCreationDate = MAX( FactArvesager[Testament creation date] ) VAR DeathDate = MAX( FactArvesager[Death of testament creator] ) RETURN DATEDIFF( TestamentCreationDate , DeathDate , YEAR ), USERELATIONSHIP(DimDato[DatoKey], FactArvesager[Date of start] ) )</LI-CODE> <P><BR />As can be seen it works fine on row level, but I need to find the Average on the 'Date of start' = 53<BR /><BR />I think I have complicated things in my head :.(<BR /><BR />Plz help</P> Wed, 22 Feb 2023 12:56:28 GMT Bokazoit 2023-02-22T12:56:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-simple-average/m-p/3092897#M108410 <P>This is an example of my data and current output:<BR /><BR /></P> <P><img /></P> <P>BoNummer is a unique key.<BR /><BR />My current measure is this:</P> <LI-CODE lang="markup">Time from creation to death in Years = CALCULATE ( VAR TestamentCreationDate = MAX( FactArvesager[Testament creation date] ) VAR DeathDate = MAX( FactArvesager[Death of testament creator] ) RETURN DATEDIFF( TestamentCreationDate , DeathDate , YEAR ), USERELATIONSHIP(DimDato[DatoKey], FactArvesager[Date of start] ) )</LI-CODE> <P><BR />As can be seen it works fine on row level, but I need to find the Average on the 'Date of start' = 53<BR /><BR />I think I have complicated things in my head :.(<BR /><BR />Plz help</P> Wed, 22 Feb 2023 12:56:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-simple-average/m-p/3092897#M108410 Bokazoit 2023-02-22T12:56:28Z