Function Placeholder

[brightonshock]

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 used as a table filter expression. This is not allowed". The thing is i have pretty much copied this from another measure which is working. The cases_grouped 1 is another measure i am 'calling' into this one. Any advice?? Thanks in advance!

a) 1-10 cases = CALCULATE (

    DISTINCTCOUNT ( weeklytrackerview[allocated_worker]),

Keepfilters( weeklytrackerview[cases_grouped1] in {"a) 1-10 cases"}),

keepfilters( weeklytrackerview[report_type] in {"Open Cases"}

)

)

[Anonymous]

Hi @brightonshock ,

Has this question been solved? If you have solved it, you can post your solution here. If any of the responses were helpful to you, please consider marking them as solutions, which will help more users find similar problems faster. If the question is not solved, please feel free to let us know. Thanks in advance!

Best Regards,
Gao
Community Support Team

[SpartaBI]

@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.

      

Showcase Report – Contoso By SpartaBI