Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating Average Percentage

Hi Everyone, 

 

I have a table which contains list of assets along with their Status and % Completion. 

Asset NameStatus% Completion
Asset1Completed100.00%
Asset2WIP25.00%
Asset3Not Started0.00%
Asset4Completed100.00%
Asset5Completed100.00%
Asset6WIP25.00%

 

When I try to cpmpute the average percentage across all assets in the table in Power BI it's showing a value way off than what is being reflected in excel. In excel, I'm using the simple AVERAGE formula to compute the total average (Progress) of all assets. 

 

 

In Power BI

 

Also, the table is merged with an additional table due to which the assets which are present in both table have their percentage being summarised. 

 

Would really appreciate for any recommendation. 

 

Thanks

 

 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， Anonymous 

    Please try formula like:

     

    Measure = AVERAGEX('Table',[% Completion])

     

    If it doesn't work, please share your sample pbix file and  expected result here.

     

    Best Regards,
    Community Support Team _ Eason

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi， Anonymous 

    Please try formula like:

     

    Measure = AVERAGEX('Table',[% Completion])

     

    If it doesn't work, please share your sample pbix file and  expected result here.

     

    Best Regards,
    Community Support Team _ Eason