Forum Discussion

nanacobsbs's avatar
nanacobsbs
Icon for Helper I rankHelper I
1 year ago

Average Dax

  The matrix is shown in Fig and Dax Dommand is bellow. Average = AVERAGE('Test'[Nov]) I would like to display the averaged results on each row, what DAX should I use? I want the total ro...
Ray_Minds's avatar
Ray_Minds
Icon for Solution Supplier rankSolution Supplier
7 months ago

nanacobsbs  Please find the solution :

Average Unit Price =

Average :=
IF (
    HASONEVALUE ( 'Test'[Date] ),
    AVERAGE ( 'Test'[Nov] ),
    CALCULATE (
        AVERAGE ( 'Test'[Nov] ),
        'Test'[Date] = MAX ( 'Test'[Date] )
    )
)