Forum Discussion

RandomKitten's avatar
RandomKitten
Frequent Visitor
7 years ago
Solved

Custom column to count matches?

I have a table that contains customers, tickets, and notes.    Each customer may have multiple tickets.  Each ticket may have multiple notes.  So the data looks something like this: What...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi RandomKitten,

     

    Try this formula as a calculated column, please.

    Column =
CALCULATE (
    COUNT ( 'table'[Ticket] ),
    ALLEXCEPT ( 'table', 'table'[Customer] )
)

    Best Regards,

    Dale

RandomKitten's avatar
RandomKitten
Frequent Visitor
7 years ago

Thank you for the link to the blog, Greg, I had looked for a way to paste the data into the original post but hadn't seen an option and was frankly too weary to bother figuring it out after having lost my original progress.  Now I know for later.  

The Note was included to illustrate that there might be duplicate rows for each ticket due to multiple activities on some tickets - which we also have to keep track of for efficiency, so I can't just scrub the data for duplicates.  

Fortunately, with a little tweaking (changing COUNT to DISTINCTCOUNT) the other response seems to be working now!