I am struggling with something I can't quite understand, and I am going sort of nuts.
I have a Data Table, no relations whatsoever, where I have a line for each Task our workforce is doing. They are sending information on the visits to stores, and checking if there is a Stock Shortage (or not) and the reason behind the shortage when there is.
I am trying to show a simple column chart with the following data:
- Values: A measure, where I guess my problem is coming from:
Visit with Shortage =
Task[Shortage] <> "No Shortage")
- Axis: The column "Shortage", where there are text values, one per line, with the detail for the shortage or, if there is no shortage, the text "No Shortage".
As an example, the table I am testing with is this:
I would want a chart with the count of tasks with the type of shortage, but not the column with "No Shortage". The graph I am obtaining is this one:
I know that I could simply add a filter to the chart, but I am more interested in learning the reason why this is not working as I intend.