I really need some help with something that is holding me back that I cannot figure out.
Below is thre table relationships.
In the report section I have set my data up in a matrix visual, based on the SR DAily Stores Issues.
What I am trying to do is add a new column or measure which will allow me to count non-blanks in the month as 1. So if there wwas a pick result every month the count would be 12. The counta and count x function gives me the same result, which is adding the total quantities of per month. But that isn't what I am trying to achieve. This is really a key missing link for me to move forward with my project and assign ABC ranking.
I cant figure out why its counting (summing) the values per column.