Cross filter without resulting in SQL INNER JOIN

cpcostaneves , if you simply join two tables and select some values in dimension table using slicer then it will filter ant measure of fact

Sum(facts_table[Value Number])

Now if you want to add a manual filter, tables are joined

calculate(Sum(facts_table[Value Number]), filter(dimensions_table, dimensions_table[Type] in {"ABC", "DEF"} ) )

you can have in like

measure =

var _tab = summarize(filter(dimensions_table, dimensions_table[Type] in {"ABC", "DEF"} ), dimensions_table[ID])

return

calculate(Sum(facts_table[Value Number]), filter(facts_table, facts_table[ID] in _tab) )