Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
The problem with Distinct count is that it is dependent on your dimension. So it is distinct per your dimension. Look at an example where I have selected one Result.
Now you have to decide that would this be part of SN or SN-HIDE in your Invoice field. Both are correct, but if you want the bar chart's sum to match with sum of straight table's row, one of the two Invoice have to go away, right? Which one would that be?