Forum Discussion

Gm0's avatar
Gm0
Frequent Visitor
6 years ago
Solved

Evaluate IF based on two values in same column

Hello Community,  I have a issue I can't wrap my head around... which I think is simple... but maybe not.  I have a column with EP numbers  A second with countries in which that EP is registred. ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Gm0 ,

    I created a calculated column to implement it. You could have a try.

    Column = 
var d = CALCULATE(DISTINCTCOUNT('Table'[Country]),ALLEXCEPT('Table','Table'[EP]))
return 
IF(d>1, "True", BLANK())

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello,

 

Have you tried to make a measure where the functions IF and AND will be combined to one. 

You will have to use a formula like this: measure = IF(AND(country = "Greece"; country = "Cyprus") true; false)