Function?

[Joshua_]

• hy Guys,
  
  I need to view sales by location when filtering by Office table.

I have been trying a cross filter measure but it is not working
for example, when filter by Name 1 (tbl_office), the result should be 3250.

Thank you

[Joshua_ · Accepted solution]

thank @AlexisOlson , I solved it by creating a variable with the Location and using the filter function.

[Joshua_]

Hi @AlexisOlson 
I'm trying whit this, but not sure if that's the way to fix it.

CALCULATE(

SUM(SALESL]),

CROSSFILTER(DATALOCATION[ID_COMUNA],TBL_LOCATION[ID_COMUNA],Both)

)

[AlexisOlson]

What does your attempted measure look like?