I have a list that stores different incidents that occur. That list feeds a Power BI report to visualize the data. Up until now each item in the list represented a single occurrence. One of our sources has changed how they report incidents though, so one item in the list may represent X amount of occurrences. To account for these I added a column that identifies the actual number of occurrences for each item. For example:
| Incident Type |
Date of Incident |
Location |
Count |
| Incident One |
1/5/2025 |
Boston, MA |
1 |
| Incident Two |
1/7/25 |
Bangor, ME |
3 |
| Incident Three |
1/9/25 |
New York City, NY |
8 |
| Incident Four |
1/9/25 |
Grand Rapids, MI |
1 |
