Totalling Issue - Maybe!

Hi @Pete673. I think what you mean by “DocCounts not totalling” is that the value returned is not what you expect; I do get a total returned for all cases, although sometimes it is zero. My first thoughts would be to:

  1. replace your sums of “naked” columns from your fact table with dedicated measures, e.g.,

Gross Sales M = SUM( SO_Fact[Gross Sales] )

  1. remove all measures from the visual physical table and ensure that my table displays and responds as desired for filter selections

  2. then review the Fix Incorrect Totals forum post and adjust the virtual tables used in your measures as necessary to mimic the physical table before re-adding the measures to the visual.

Good luck.
Greg