Cross-Table / Variable weird error

[former_member668808]

I've got a cross-table in WebIntelligence that has a variable (a Detail) for the column headings and I've finally managed to cobble together a measure that pulls through the number of instances in the body below each column heading. One of the column headings is blank, and if I filter that out all of the numbers in the body change completely. The figures don't represent the reality at all and I can't figure it out. Images below show before and after the filtering:

The above shows what I see before I filter. The numbers are correct. However, once I apply a filter on the column headings to get rid of the Null/Empty Values, the table is as follows:

Looking at the first row under the column headings, there should be a '2' under Column 5 but it's completely disappeared. I've tried so many workarounds to try and get this to work but it's just not happening. Any advice/guidance from anyone, please?

[ayman_salem · Accepted solution]

I have tested your data and received the correct answer.

Note the last two tables, one with the CNr variable and the other with the CNr_NoFilter variable.

CNr: =Count([Person];All)

CNr_NoFilter: =NoFilter(Count([Person];All))

...

Both tables are filters with "Absence type is not null".

....

I notice that in the data you wrote earlier, "Team D" has no "absence type" and therefore does not appear in tables

...

hope that will help you