topic Re: Average Dax in DAX Commands and Tips

Average Dax

nanacobsbs — Tue, 11 Mar 2025 05:41:23 GMT

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 row to have the same value as the maximum of the selected DATE numbers.

Re: Average Dax

bhanu_gautam — Tue, 11 Mar 2025 05:56:34 GMT

nanacobsbs , Try using

DAX
Average =
IF(
HASONEVALUE('Test'[DATE]),
AVERAGE('Test'[Nov]),
MAXX(ALL('Test'[DATE]), 'Test'[Nov])
)

Re: Average Dax

nanacobsbs — Tue, 11 Mar 2025 06:13:58 GMT

Thank you, but it does't work.

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

Re: Average Dax

bhanu_gautam — Tue, 11 Mar 2025 06:20:37 GMT

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]
)
)
)

Re: Average Dax

nanacobsbs — Tue, 11 Mar 2025 06:40:08 GMT

It doesn't work.

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

Re: Average Dax

v-aatheeque — Sun, 04 May 2025 14:26:27 GMT

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!

Re: Average Dax

v-aatheeque — Thu, 08 May 2025 11:18:03 GMT

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!

Re: Average Dax

v-aatheeque — Tue, 13 May 2025 07:11:58 GMT

Hi nanacobsbs ,

Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

Re: Average Dax

v-aatheeque — Sun, 18 May 2025 17:52:43 GMT

Hi nanacobsbs ,

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

Thank you!

Re: Average Dax

nanacobsbs — Mon, 19 May 2025 08:04:32 GMT

Thank you for your comment.

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

Re: Average Dax

v-aatheeque — Thu, 22 May 2025 13:00:10 GMT

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.

Re: Average Dax

nanacobsbs — Fri, 23 May 2025 07:52:58 GMT

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.

Re: Average Dax

Ray_Minds — Fri, 23 Jan 2026 10:14:47 GMT

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] )

)