I want to create visualization that will show the total number of 'As', 'Bs', 'Cs' and 'Ds' in my four columns. So the result should be:
A - 5
B - 4
C - 2
D - 1
What I did was: I choosed Clustered Bar Chart > Insert Column 1 in Values > New Quick Measure > Addition > Added Colum 2 > New Quick Measure > Addition > Added Column 3 > New Quick Measure > Addition > Added Column 4.
What I got is this:
As you can see, this is not the result I wanted. I got 6 Bs, 4 As, 2 Cs, and no Ds, which doesn't correspond to the real data.