DAX SUM with filter in another table

[Alin_Tod]

Hi,

I know this is a simple one but I cannot manage it so far.

I wanna calculate the sum o payments from a table Table1 (with 100 clients) only for the clients presented on another table Table2 (only 10).

Hope I was clear.

Thanks

[Icey · Accepted solution]

Hi @Alin_Tod ,

How about creating a measure like so:

Measure =
CALCULATE (
    SUM ( Table1[payment] ),
    FILTER ( Table1, Table1[client] IN VALUES ( Table2[client] ) )
)

In addition, no relationship between Table1 and Table2.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Alin_Tod , Try to use treatas

https://docs.microsoft.com/en-us/dax/treatas-function

[Alin_Tod]

thanks for your response @amitchandak . I was trying your formula but i cannot select the second's table client column in formula.