Frequency calc / Histogram

It's a frequency table... My column headings were perhaps not clear... The figures are the count of the number of 'occurrences' rather than the number of visits. The table reconciles to 6 visits as follows - [(1+2)]*1] + [(0+0)*2] + [(1+0)*3] = 6 visits.

           ABC             XYZ

Freq    #occur          #occur       Total #visits

1           1                 2                 three times to the same site on only occasion, one for ABC & two for XYZ

2           0                 0                 no visits to the same site twice, by either customer

3           1                 0                 once to the same site three times, by one of the customers (ABC)

1   Visited a single site on ONE occasion only - ABC - 1 occurrence visited site 123 , XYZ - 2 occurrences visited sites 123 and 345 = 3 visits in total

2   Visited a single site TWICE - none

3   Visited a single site on THREE occasions - ABC - 1 occurrence visited site 345 three times

Hope that helps explain! The DAX logic is beyond me...  I could probably do it in Excel, using countif but the database is 100's of thousands lines long so teh spreadsheet would be slow and the ability to cut and dice the results (by period, customer, etc.) would be limited without a lot of manual effort.

Cheers