Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax formula help: Sorting distinct entries by frequency

Hi all,   I'm dealing with a lot of data from a call centre, and I am trying to investigate how many people contact us multiple times. I can ise DISTINCTCOUNT to find out how many different number...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks,

 

Definitely along the right track, the only issue is that I need to be able to slice this down to a certain amount of time, and have it just show the number of repeat callers in that timeframe. Essentially, I need to be able to adapt the custom column so that it just checks against earlier calls within the sliced timeframe.

sanct's avatar
sanct
Frequent Visitor
7 years ago

Have you tried using a date dimension to slice your central table?

 

Some more info about the data model you're working with would be helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have a date table linked to the call log that I can use to slice different dates. Ths issue is that using the method above I am pulling values a column that counts entries going all the way back to the start of the contact log. I need to be able to make it so that the new column only counts entries between the dates I am choosing on the slicer, to see how many people made multiple calls between selected dates.