DAX表计算powerBI多列值

Question

我想从我的数据集中选择多个城市，并使用这些城市创建一个子集，但是有些城市在不同的州有相同的名称。因此，我只想选择马萨诸塞州的波士顿。为此，我创建了以下查询，但它似乎给了我一些错误。我该如何解决这个问题?

10_least_weather = 
CALCULATETABLE(
Weather_records
,AND(
Weather_records[City] 
IN {"New York"
,"Gilbert"
,"Las Vegas"
,"Huntington Beach"
,"Boston"
,"Paterson"
,"Naperville"
,"Cedar Rapids"
,"Arvada"
,"Santa Clarita"
}
,Weather_records[State] 
IN {"MI", "SC", "IL", "PA", "FL", "PA", "SC"}
)
)

Answer 1

检查

FILTER(
Weather_records
,SWITCH(
TRUE()
,[State]="State1" && [City]="CityName1",TRUE()
,[State]="State2" && [City]="CityName2",TRUE()
,[State]="State3" && [City] IN {"CityName31","CityName32","CityName33"},TRUE()
,[State]="State4" && NOT [City] IN {"CityName41","CityName42"},TRUE()
...
,FALSE()
)