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.

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

I have tried that, using ALLEXCEPT on the two tables that filter the results on page-level, but the issue is some of those are also included in the actual table visual, so they filter the AVERAGE calculation to a single item.

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.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.


Regards,
Dinesh

  • SevsBo's avatar
    SevsBo
    Icon for Responsive Resident rankResponsive Resident
    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.