Forum Discussion
Distinct count filtered Average
I am looking to get an average of Days in ops based on distinct Request # I tried : Ops Average Age = divide(sum(OfficeTrax[Days in OPS]),distinctcount(OfficeTrax[Request #])) But it doesnt ...
v-juanli-msft the new table worked for me to get accurate averages. But now when i filter the rest of the data these averages do not interact with the rest of the page
Hi abehrmann
I guess the original table has some relationship with other tables, you want your new table interact with with other tables too.
Please show me some example of other tables and what you want to show in this new table when filter in another table.
Best Regards
Maggie