Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running Total Showing Wrong Values

I am using the below function to calculate the 12 month running total of items. When all the periods are listed every thing works great. However if I filter and a period is missing a MYSTERIOUS "2" ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to resolve the issue by adding a seperate date table and not use the date in the main table. I do not know why this fixed the problem or why PBI was putting a MYSTERIOUS 2 when it should have been Null or Zero.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

I assume that Items is a measure which is calculated as = DISTINCTCOUNT( 'Extract (Header)'[issueNumber]).  If my understanding is correct, then how can you add distinctcount entries.  By its very nature, distinctcount cannot be additive.