Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Check if the combination occurs within a table

I have a table. I want to create a column for evaluating if the combination occurs within a table.   See the example below: Name Category Ok/NotOk A PDE OK A KDE OK B PDE OK ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Try this, create the column,

    Ok/NotOk = 
var _count=CALCULATE(COUNTROWS('Table'),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Category] = "PDE"))
return IF(_count>0,"OK","NotOK")

    result

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

Try this, create the column,

Ok/NotOk = 
var _count=CALCULATE(COUNTROWS('Table'),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Category] = "PDE"))
return IF(_count>0,"OK","NotOK")

result

 

Best Regards,

Community Support Team _Tang

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