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...
nanacobsbs's avatar
nanacobsbs
Icon for Helper I rankHelper I
1 year ago

Thank you, but it does't work.

I would like to get the following calculation results.
Is it possible?

 

 

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

nanacobsbs Try this one

 

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

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

    It doesn't work.

    Dax command has some error, so I put "SUM" infromt of 'Test'[Nov]

     

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity 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!




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

        Hi nanacobsbs ,

        We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

        If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
        If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

        Thank you!