Goal: Show the 'n' for a question (# of non-null respondents to that question) possibly by event; have tried various LOD's without success.

Screen shot below is what I'm trying to obtain.

I have tried:

COUNTD([ResponseID]), set as a dimension or discrete-> wrong level of detail (see sheet RespAsDim)

LOD expressions such as {FIXED [Q Name],[Event ID]:COUNTD([Response Id])} set as dimension or discrete -> wrong level of detail (see sheet LOD Fixed). I have also played with variations in INCLUDE, FIXED and EXCLUDE unsuccessfully.

Packaged workbook with dummy data attached (of course, this workbook is ugly, and would go through many improvements and formatting changes before it would be ready for use). I’m just trying to set up the initial calculations right now on a representative subset of data.

Thanks!