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)

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

try this:

 

Column = if(CALCULATE(COUNT('Table'[host_id]),ALLEXCEPT('Table','Table'[date]))>2,1,0)
 
basically it's counting the the host id but changing the context to only count against the exact date.
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍