Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Icon for Post Patron rankPost Patron
5 years ago
Solved

problem with a formula with related

Hi, I have two samples tables with a relation: orders and people, I want do create a formula like this but it gives me an error   SUMX(FILTER(Orders; RELATED(People[Person]= "Anna"); Orders[Sales...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Giada_Togliatti ,

     

    Try re-writing your DAX as follows. I think you have missed a closing bracket:

    SUMX(

    FILTER(Orders; RELATED(People[Person]) = "Anna");

    Orders[Sales]*Orders[Quantity])

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Giada_Togliatti ,

 

You query is incomplete as you haven't attached anything regarding the error you are getting.

 

Thanks,

Pragati

  • Giada_Togliatti's avatar
    Giada_Togliatti
    Icon for Post Patron rankPost Patron
    5 years ago

    Hi,

    the error is this:

    Too many arguments were passed to the FILTER function. The maximum argument count for the function is 2.

    Thanks