Forum Discussion
Subtotal isn't adding up correctly
Hi all, We are looking for a measure that finds new customers per month. To do this we are looking at the sales 12 months prior. Whenever a customer has no sales for 12 months and has sales the 1...
Hi Anonymous It might be because the measure NewCustomerCount_Monthly evaluates subtotals in the overall context instead of summing individual rows, leading to incorrect aggregation. To fix this, use SUMX to explicitly iterate and sum the row-level results.
Akash_Varuna
Super User
Super UserHi Anonymous It might be because the measure NewCustomerCount_Monthly evaluates subtotals in the overall context instead of summing individual rows, leading to incorrect aggregation. To fix this, use SUMX to explicitly iterate and sum the row-level results.
HI Akash_Varuna. How would you change the two measures using SUMX?