I was using the sumx formula you suggested and it all looked great. Today I realized there is a mistake (not really a mistake, but when I asked for help I created a simpler example than the one I work with, my real report requires more).
So, in my real report, I use multiple filters. When filtering by month or sales code I get the distinct count total correct (considering row by row values), but when I filter according to any other variable, such as product, country, customer, transport, etc... the distinct count total value does not match the row by row sum.
I tried with all the formulas and the ones with the Hasonevalue but I get mistakes either when filtering by sales code or by month.
Can you help me with this issue please, I attach the file so you can better understand and visualize what I am saying: Distinct Count Example 2
I tried adding the filter variables in the sumx and summarize formula and still got the incorrect total. I know you suggested me not to use summarize formula but I tried to see if that formula works in this case.