How to implement Business Rules?

[Cookistador]

Hi Everyone,

I'm facing a new issue on Power BI
I would like to add some business rules in a smooth manner for the business user

Imagine, I have a measure like this one:

TargetDepartmentSales = Calculate (Sum(Table['Sales']), Table[City] in {'Arles','Caen','London','Dublin','Berlin','Toronto','San Diego',...) (I use more than 50 cities in this measure)
The idea, would be to store these values in an excel files and allow user to update this table with a powerapps and then read the values via lookup function, so to do that, I could transform my measure in

TargetDepartmentSales = 

TargetDepartmentSales = 
VAR FilteringMeasure = LOOKUPVALUE(Table1[Condition],Table1[Name],"Cities")

RETURN(Sum(Table['Sales']),Table[City]  in {FilteringMeasure})

But my measure returns Blank, however if I return my Lookupvalue, it returns the correct string: ' Arles','Caen','London','Dublin','Berlin','Toronto','San Diego',...

Any idea of how can I solve this problem?

Many thanks for your help

[amitchandak]

@Cookistador , if that table only contains city in a column(The separate table is city)

Sum(Table['Sales']),filter(Table, Table[City] in Values(City[City]) ) )

Or you can try treatas

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Cookistador]

Thank you for your reply

But indeed, the table did not contains values only from cities

My idea was to create a table with all filtering conditions like this table, so one line by filter condition

Cities	'San Diego','Dublin','London',...
Customer	'Siemens','Eaton','Allen Bradley'

This is why I would like to use the Lookupvalues, but maybe I wont have other choice than creating one table by filter