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.
v-kathullac
Community Support
Community SupportHi @Muratmet123 ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.