Forum Discussion
Responsive ResidentCompare total average to per-row average?
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.
Super UserHi,
If the number of columns to be retained are lesser than the ones which need to be cleared, then consider using the ALLEXCEPT() function.
SevsBoI 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-dineshyaCommunity Support
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
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.