problem with a formula with related

[Giada_Togliatti]

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]*Orders[Quantity]))

How can I do?

Thank you

[Pragati11 · Accepted solution]

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

[amitchandak]

@Giada_Togliatti , related will only work from 1-M direction. M table can use related. If they are joined, This should also work

SUMX(FILTER(People; People[Person]= "Anna"); Orders[Sales]*Orders[Quantity])

[AlB]

Hi @Giada_Togliatti 

What is this, a measure?

Assuming there's a 1-to-many relationship between People and Orders, you can do:

Measure =
CALCULATE (
    SUMX ( Orders; Orders[Sales] * Orders[Quantity] );
    People[Person] = "Anna"
)

 althought it would bemuch better to place People[Person] in a slicer and select Anna there. Int that case the measure would be simple and more versatile:

Measure = SUMX ( Orders; Orders[Sales] * Orders[Quantity] )

If this doesn't work share the pbix 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Giada_Togliatti]

Hi,

thank you, the solution with calculate works, I'm learningdax, how can I achieve the same result using RELATED, something similar to the formula I posted?

Orders in in many side while people is in one side

[AlB]

@Giada_Togliatti 

It doesn't make much sense to use RELATED in this scenario.

It would perhaps if you needed to obtain a value from the the Person table. You already have that value here ("Anna")

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Pragati11]

Hi @Giada_Togliatti ,

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

Thanks,

Pragati

[Giada_Togliatti]

Hi,

the error is this:

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

Thanks