Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Total for Avg Column does not AVG properly

HI, I am still learning BI and need your help on the below:   First problem is the total for the avg column does not average properly (have tried, sumx and avgx)     Second problem, is my ...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could custom your total values like the following DAX with ISINSCOPE() function:

Measure =
IF (
    ISINSCOPE ( 'Table'[KGS] ),
    [Avg KGS per HBL],
    AVERAGEX ( ALLSELECTED ( 'Table' ), [Avg KGS per HBL] )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI V-achen, I tried your formula and the total for the average column is still wrong