ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Un-weighting an average value Oh my gosh that's so embarrassing. Yes I meant 200. I have revised the original question. Thank you so much for jumping in and helping out! Un-weighting an average value Hello all, I have what I hope is a simple question. We have a database that can be boiled down to the image below. Each entry has a date (YYYYMM) and whatever the monthly member count is for that entry (Members). We want an average member count of Q4 (202110, 202111, and 202112), but the only way I can get Sisense to calculate that is: 100 + 100 + 100 + 100 + 200 + 300 / 6 = 150. However, there are duplicate member counts/YYYYMMs here. I want it to do it by distinct YYYYMM, like this: 100 + 200 + 300 / 3= 200. Different months can have identical member counts. Does anyone have any ideas? SolvedRe: Un-weighting an average value avg([YYYYMM],avg([Average Members])) I figured it out this morning. Breaking it by YYYYMM, then taking the average's average (which will always be the same across the same month). Re: Un-weighting an average value That still gave me the 150 answer, but see below, I figured it out this morning.