Forum Discussion

kumsha1's avatar
kumsha1
Icon for Post Patron rankPost Patron
4 years ago
Solved

Incorrect column totals average

Hi,   In the table visual below, the row wise average seems ok but the column totals average is incorrect. Can someone let me know what might have gone wrong here and help to rewrite the DAX, as of...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi kumsha1 

     

    Download example PBIX file.

     

    Use this measure

    AvgX = AVERAGEX('DataTable', DIVIDE(SUM('DataTable'[DailyValue]),SUM('DataTable'[DailyPlanValue]))) * 100

     

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi kumsha1 

 

Download example PBIX file.

 

Use this measure

AvgX = AVERAGEX('DataTable', DIVIDE(SUM('DataTable'[DailyValue]),SUM('DataTable'[DailyPlanValue]))) * 100

 

 

Regards

 

Phil