How to use "If" in "New Measure" to check the another field?

[KH_Mike]

Hello All,

I am trying to use the "New Measure" to hardcode the "Target" number. However, I am not sure how to check the data column in order to return the correct "Target".

My formula is like this but it won't work.  

If ( Data[Type] = "A" , 100 , If ( Data[Type] = "B" = 200 , If ( Data[Type] = "C" = 300 , 0 )))

[KH_Mike]

Hi All,

I try to use max on for each Data[Type] and it do return the result I want. However, why the "Total" is not the sum by all those figure? Now, the "Total" is 300 .......

[amitchandak]

@KH_Mike , Try one of the two ways.

Sumx(Data,
Switch ( True(),
Data[Type] = "A" , 100 ,
Data[Type] = "B" = 200 ,
Data[Type] = "C" = 300 , 0 ))

Sumx(Values(Max(Data[Type])), calculate(
Switch ( True(),
Max(Data[Type]) = "A" , 100 ,
Max(Data[Type])= "B" = 200 ,
Max(Data[Type])= "C" = 300 , 0 ) ) )

[KH_Mike]

Hi @amitchandak 

I tried to use your method but it will come out few thousand for A and few thousand for B. Is it because I have many serval A and B records?