Forum Discussion
Wrong Total in Matrix while using Distinctcount
That is what I thought...
If a customer bought something in february and march, it will only be counted once for february, once for march, and once for the total. This is what DISTINCTCOUNT does.
In your case, you may want to use a SUMX function in your measure to force the results you want.
Edit: How should the measure behave when you show your data on a daily basis? Again, if a customer bought something on the first and the second of january, how many times should it be counted for the month of january (subtotals).
That is what I thought...
If a customer bought something in february and march, it will only be counted once for february, once for march, and once for the total. This is what DISTINCTCOUNT does.
In your case, you may want to use a SUMX function in your measure to force the results you want.
Edit: How should the measure behave when you show your data on a daily basis? Again, if a customer bought something on the first and the second of january, how many times should it be counted for the month of january (subtotals).
