I have a (heavily redacted) table containing events since 1st January 2016.
The table presents the customers in regions, location types and locations. Each customer can generate two types of events (serious and reportable) on three different categories (accident, incident and behaviour)
The file is attached:
MockUp_v2.xlsx (1.8 MB)
A simple DISTINCTCOUNT() does the trick beautifully, at the total level. However, when I introduce some filter context, the breakdown goes horribly wrong.
I am aware of the warning in the documentation (Microsoft Doc, but I needed it translated into English…
The reason I don’t get this explanation is that a much smaller example works perfectly well:
MockUp.xlsx (121.6 KB)
I’ve spent about two days trying to understand this, but in vain.
Any help will be appreciated.