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.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
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.

Gm0's avatar
Gm0
Frequent Visitor
6 years ago

Thanks all for your input!