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:
- replace your sums of “naked” columns from your fact table with dedicated measures, e.g.,
Gross Sales M = SUM( SO_Fact[Gross Sales] )
-
remove all measures from the visual physical table and ensure that my table displays and responds as desired for filter selections
-
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