Expressions that yield variant data-type cannot be used to define calculated columns

lbendlin  Abbott account should be displayed in the table chart because it matched the condition (Forecast > 500k) , this is the expected result .

If i use SWITCH condition then the result is coming but also error occurs , if i use IF condition then the result is not coming (Abbott is missing) , so how to retrieve the correct result with any one of the above DAXs ?

For example :

Row 1 : Account name is AAA, Offer type is Q and Forecast value is 2334
Row 4 : Account name is AAA , Offer type is A and Forecast value is 499523 then the sum of the AAA is >500K then it is "Yes". if row 1 & row 4 has less than 500K forecast value then it is "No" 

Same logic for row 2 & 6 , I need to add this calculated column "Key Accounts" into page filter pane and select Yes or No in different bookmarks. So the account name should be unique with summing forecast values when it publishing in the table visual (no duplicate account names displaying)