Forum Discussion
YTD DistinctCount not totaling correctly
Hi,
The problem is in Feb. The # adds upto 426 though it should add up to 427. It means that there is a member being considered both in new and old in that month itself. Check your data. Make the corrections mentioned in my previous post.
Hi,
The problem is in Feb. The # adds upto 426 though it should add up to 427. It means that there is a member being considered both in new and old in that month itself. Check your data. Make the corrections mentioned in my previous post.
Doing an additional measure over each monthly, YTD, YoY, YoYTD measure with the below template gave me the exact totals I was looking for. So I believe it is now doing a SumX for each month, and a SumX for each Row, which works perfectly.
Measure = SUMX(VALUES(Heloc3MonthAdvances[Existing/New]),[MemberNumberYTD DISTINCTCOUNT])
Thank you!!!!!
You are welcome.