topic Dax Filter on Measure in DAX Commands and Tips

Dax Filter on Measure

MBegum — Wed, 14 Apr 2021 16:00:25 GMT

Hi all,

I am new to DAX expressions and am trying to work out the current academic year based on the start and end dates. I have managed to write a dax expression in DAX studio using filter() function which returns the result expect but when I apply this to a measure in Power BI Desktop I get the error message "too many arguments were passed to the filters function. The maximum argument count for the function is 1)".

Could someone help and advise what I'm doing wrong?

example of the table

dax formula created

Error in Power BI desktop

Thanks

Monju

Re: Dax Filter on Measure

AlexisOlson — Wed, 14 Apr 2021 16:05:11 GMT

It looks like you wrote FILTERS instead of FILTER in desktop.

Re: Dax Filter on Measure

MBegum — Wed, 14 Apr 2021 16:34:35 GMT

I tried with FILTER() too and am still getting the same error.

Re: Dax Filter on Measure

AlexisOlson — Wed, 14 Apr 2021 20:41:13 GMT

That doesn't make sense. It should at least give a different error since FILTER expects two arguments.

Re: Dax Filter on Measure

MBegum — Thu, 15 Apr 2021 09:10:39 GMT

Apologies, the message is slightly different. I'm a confused as to why the dax expression works in DAX studio but not in Power Bi.

Re: Dax Filter on Measure

AlexisOlson — Thu, 15 Apr 2021 14:03:58 GMT

Are you defining CYOE as a calculated table? The error makes me think you are trying to define a measure or a calculated column with a table definition, which doesn't make sense.