Forum Discussion

mclawler's avatar
mclawler
Icon for Helper III rankHelper III
1 year ago
Solved

YTD DistinctCount not totaling correctly

I have this table attached to a slicer and everything after January for the YTD# column(distinctcount member number) seems to subtract 1 from the overall total row.  Please advise.  I have tried ever...
Need Help
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    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.

     

mclawler's avatar
mclawler
Icon for Helper III rankHelper III
1 year ago

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!!!!! 

Ashish_Excel's avatar
Ashish_Excel
Icon for Solution Supplier rankSolution Supplier
1 year ago

You are welcome.