Forum Discussion

SevsBo's avatar
SevsBo
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

Compare total average to per-row average?

We're trying to show how items in ColumnA compare against the average for all of the items, then to calculate actual and percentage-based difference to find the biggest outliers. This is shown in a t...
Need Help
  • SevsBo's avatar
    SevsBo
    1 year ago

    Issue was resolved by creating a calculated table based on the Page-level filters, and calculating relevant averages within that table. This is was then used in measures within the existing tables to derive variance between row-calculated averages and absolute averages for the data.

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi SevsBo ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi amitchandak , Ashish_Mathur , Thanks for your prompt response.

 

Hi SevsBo , If amitchandak , Ashish_Mathur  responses has resolved your query, Please mark their responses as  "Accept as solution" , to assist other community members in resolving similar issues more efficiently.

Regards,

Dinesh