Forum Discussion

twowaysyellow's avatar
twowaysyellow
Frequent Visitor
3 years ago
Solved

Creating a calculated column that indicates count number of another column range

Apparently I'm completely missing something very basic, I have tried all morning - even being smashed around by ChatGPT :-).   I have a table with ticket_id's for every guest at certain events host...
Need Help
  • twowaysyellow's avatar
    twowaysyellow
    3 years ago

    Thanks, it almost worked, but I managed to tweak it a bit with a little help. This is what ended up working: 

    Column = if(CALCULATE(COUNTROWS(Table),ALLEXCEPT(Table,Table[host_id],Table[date]))>2,1,0)

twowaysyellow's avatar
twowaysyellow
Frequent Visitor
3 years ago

Thanks, it almost worked, but I managed to tweak it a bit with a little help. This is what ended up working: 

Column = if(CALCULATE(COUNTROWS(Table),ALLEXCEPT(Table,Table[host_id],Table[date]))>2,1,0)