I am trying to count occurrences of a QR code entry in to a DB each day and display the last 7 days of counts. I would like to include zero counts.
The top graph is using QR Code (count) for the Y axis and the filter is correctly applied. The problem is it skips days where there are no occurrences.
The bottom graph uses the following measure for the Y axis.
Count = COUNT(‘db'[QR_Code]) + 0
It now counts the zeros but doesn’t apply the Date filter correctly.
I can’t seem to get this to work, please help!
enter image description here
New contributor
Jordan Ford is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.