I have attempted a LOD calculation that ignores my date filter and I think I am NEARLY there but for some reason, depending on which month I filter to, some records still filter out.

Example: I have a list of individuals [Performer] and their number of victories [Total Wins by Performer] at specific events [Event Type]. I want to display in a bar chart their total count for performance for [Event Type] in a specific month [Date]. I also want to compare that to a benchmark of their performance over the year.

When I display this with no filters other than Event Type, I get a number. When I add the [Date] filter and change it to a specific month, I would say most of the time the number stays static but every now and then a number will change for one performer, maybe two, when I change the filter to a single month.

UPDATE: I have isolated some of it. When I change filter by month, some of the [Event Type] records disappear for certain performers as the [Event Type] does not always exist for that performer for that month. So, I need a LOD calc that will ignore the [Date] filter but also hold on to the Event Type filter, while still giving me that year-round total.

In case of FIXED LOD, All your Filters need to go to CONTEXT means need to get evaluated first to get subset of data suppose you have selected Month as January then FIXED LOD will only operate on that Subset. So add filters to CONTEXT by Right Clicking on Filter in Filter Shelf and use add to context.