Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Column IF AND Statement

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.
 
Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.