Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
1 year ago
Solved

Calculate reference average line using DAX

Hi Team, Urgent help! Problem: Want to calculate the average reference line using DAX instead of using the line chart option. PBIX File  This average reference line should be dynamic to whate...
"DAX Commands and Tips"
  • gmsamborn's avatar
    gmsamborn
    1 year ago

    Hi SUMESHKUMAR22 

     

    Would a measure like this help?

    _My Avg = 
AVERAGEX(
    ADDCOLUMNS(
        SUMMARIZE(
            ALL( 'Sample' ),
            'DIM Date'[Date],
            'Dim_Channels'[Channel]
        ),
        "__Value", [current base sum cal]
    ),
    [__Value]
)

     

    Let me know if you have any questions.

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
1 year ago

Hi Team,

Replaced the new pbix file within the above link. Please refer the Dax average line & in built average line . Let me know which is calculating the correct average?

Thanks!

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

Hi SUMESHKUMAR22 

 

Would a measure like this help?

_My Avg = 
AVERAGEX(
    ADDCOLUMNS(
        SUMMARIZE(
            ALL( 'Sample' ),
            'DIM Date'[Date],
            'Dim_Channels'[Channel]
        ),
        "__Value", [current base sum cal]
    ),
    [__Value]
)

 

Let me know if you have any questions.