Get sales with another field (not key) of table.

[Joshua_]

hi,
I need to get the sale of the area, using Id Department.


For Example, If filter by Area Metro, result should be $ 10,000.

Thank a lot.

[az38 · Accepted solution]

Hi @Joshua_ 

try measure

= calculate(SUM('Sales Table'[Sales]); Filter(ALL('Sales Table');'Sales Table'[ID]=SELECTEDVALUE([ID_Area]))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Joshua_]

Thank @az38 , its working.