Dax Filter on Measure

[MBegum]

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

[AlexisOlson]

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

[MBegum]

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

[AlexisOlson]

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

[MBegum]

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.

[AlexisOlson]

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.