Forum Discussion
Function Placeholder
Hi all, I'm currently trying to do a distinct count whilst using keepfilters - dax below. I am getting a message saying "A function placeholder has been used in a true/false expression that is us...
brightonshock you can't put a "naked" measure as 1 of the filter arguments of calculate.
You will need to wrap it with filter to look something like this:
KEEPFILTERS(
FILTER('some table/columns', [cases_grouped1] in {"a) 1-10 cases"})
)
CALCULATE FILTERS ARE TABLES.
Also a very important note: when you reference a measure in a formula never put the table name before it (only in columns), this is very confusing. good thing you said it's a measure after.