I'm counting the amount of entries in a server table that the TRANS_YEAR is 2017. Not sure what you mean by a QVF file sorry - pretty sure we don't use them. The table has hundreds of thousands of entries.
A thought - how would I modify that function so instead of it returning a 0 it returns NULL - and then so long as I have the option of Show Null Values in the Dimension it wont show anything? Is that even possible?