Forum Discussion
table for all combinations
Hi, how can I get a new table showing each combination of systems issues, and have a date filter so the combinations change with the monthly filter changes? In my real-life scenario I have hundreds of combinations, but for this I need January to show 4 login and 2 email, and February to show 2 login and 5 email please.
| System | Issue | Date |
| Laptop | Log-in | 01/01/2025 |
| Laptop | Log-in | 01/01/2025 |
| Laptop | Log-in | 01/01/2025 |
| Laptop | 01/01/2025 | |
| Laptop | Log-in | 01/01/2025 |
| Laptop | 01/01/2025 | |
| Laptop | 01/02/2025 | |
| Laptop | 01/02/2025 | |
| Laptop | 01/02/2025 | |
| Laptop | 01/02/2025 | |
| Laptop | 01/02/2025 | |
| Laptop | Log-in | 01/02/2025 |
| Laptop | Log-in | 01/02/2025 |
Thanks
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,
4 Replies
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,
Hi RichOB
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi RichOB
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi RichOB
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
