Forum Discussion

Sander_NL's avatar
Sander_NL
Helper I
4 years ago
Solved

Check if multiple rows have same value than status OK else NOK in new column

Good evening,   I have a table with the following columns/rows and I'm looking for a way to create the new column overall status. I know how to do a check row by row but now I need to check all the...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Sander_NL ,

    Try a new column =

    var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )

    return

    if(_cnt=1, "OK", "NOK")

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Sander_NL ,

Try a new column =

var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )

return

if(_cnt=1, "OK", "NOK")

 

kellysolutions's avatar
kellysolutions
Frequent Visitor
2 years ago

Hi,

 

This is very useful, thank you.

The first line works fine for me, but when I try the return and if, i get a syntax error. As soon as I type return it redlines.

var _cnt = calculate(distinctcount('Active Agreements'[Difference]), filter('Active Agreements', [Agreement Number] = earlier([Agreement Number]) ) ) return