Forum Discussion

MBegum's avatar
MBegum
Frequent Visitor
5 years ago

Dax Filter on Measure

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

5 Replies

    • MBegum's avatar
      MBegum
      Frequent Visitor
      5 years ago

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

      • AlexisOlson's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        5 years ago

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