Forum Discussion

nanacobsbs's avatar
nanacobsbs
Helper 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...
v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi nanacobsbs ,

can you try the below Dax query :

RunningAverage =
IF(
    HASONEVALUE('Test'[DATE]),
    AVERAGEX(
        FILTER(
            ALL('Test'[DATE]),
            'Test'[DATE] <= MAX('Test'[DATE])
        ),
        'Test'[Nov]
    ),
    AVERAGEX(
        ALL('Test'[DATE]),
        'Test'[Nov]
    )
)


If the issue persists share the sample date for better understanding.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!




nanacobsbs's avatar
nanacobsbs
Helper I
1 year ago

Thank you for your comment.

I tried above DAX command, but it doesn't work like below.

 

 

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi nanacobsbs,

    can you try this :

    Average Display =
    IF (
        ISINSCOPE('Test'[Date]),
        CALCULATE(AVERAGE('Test'[Nov])),
        CALCULATE(MAXX(VALUES('Test'[Date]), CALCULATE('Test'[Nov])))
    )

     

    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    • nanacobsbs's avatar
      nanacobsbs
      Helper I
      1 year ago

      Thank you for your comment.

      I tried above DAX command, but it doesn't work like below.
      If the total had shown 26.77 it would have been good.