New Column IF AND Statement

[Anonymous]

Hello,

I am trying to categorize test results sent to an entity inside India or outside India. First I created two measures that filtered on location as either "India" or "Not India" and then created a column with the following IF AND statement:

Domestic or Abroad? = IF(AND(

vPBIScoreReports[# Score Reports for Not India] <=1, vPBIScoreReports[# Score Reports for India] > 0),

"Domestic", "Abroad")

The result of this is below in the leftside table, however when I remove the newly created colum on the rightside I see that these items are not being catagorized correctly. The row with 9 in the India Column and 2 in the Not India Column should be labled as "Abroad". Any help troubleshooting this would be much appreciated.

[v-juanli-msft]

Hi @Anonymous 

Sorry, i can't find the problem from your screenshot, could you clear me in details?

My test is as below:

I create three measures, it works well either adding all three measures or any measure in the table visual.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.