Dax referring Excel

[Anonymous]

Hi All,

 I have two files country detail & Id. Result will be country & value for specific ID & code

Country

India

Pakistan 

Bangladesh 

Srilanka

Value       ID       Code

55          24          C1

42           8           C2

60           8           C3

70           25         C4

I write a Dax like

Country Values = 

Var Country = SelectedValues(Country)

Var India_Value = Calculate(sum(Values),Id=8,Code=C3)

Var Result = Switch(Country,"India",Indian_Value)
Return
Result

I have to write for more condition,for all those condition can I refer from excel file and specifiy column name in condition place will it work

[rajulshah]

@Anonymous ,

You sure can do that, but that is not advisable. Do you have any column in tables that can be used to relate both of them? If so, you just have to write one measure, and everything would work automatically.