table for all combinations

Hi RichOB ,

To create a dynamic table that shows the count of each combination of system issues filtered by month, start by creating a date table if you don't already have one. Use the following DAX formula to generate it:

DateTable = 
ADDCOLUMNS (
    CALENDAR ( MIN('YourTable'[Date]), MAX('YourTable'[Date]) ),
    "Month", FORMAT([Date], "MMM YYYY"),
    "Year", YEAR([Date])
)

Then, create a relationship between 'YourTable'[Date] and 'DateTable'[Date]. In your report, use a matrix or table visual. Place System and Issue as rows (or columns, depending on preference), and add a measure to count the occurrences like this:

Issue Count = COUNTROWS('YourTable')

Next, add a slicer or filter using 'DateTable'[Month] or 'DateTable'[Date] to control which month's data is displayed. When you select January 2025 in the slicer, the table will show 4 log-in and 2 email issues. Selecting February 2025 will show 2 log-in and 5 email issues. The visual will automatically update based on the selected date filter.

Best regards,