Forum Discussion

Dgrooves's avatar
Dgrooves
Regular Visitor
3 years ago

Distinct count with phone numbers in Table

So I'm new to DAX and I know this is pretty basic. I'm just trying to create a measure based on how many of the same numbers called during a period of time. On a separate visual show the top 10 using TOPN

My formula: 

Call Count Measure := DISTINCTCOUNT('Full Call Sheet'[Calling Party Number])
All I'm getting back is just the total of calls instead of a table with Phone number and the number of times they're called.  Any help would be greatly appreciated. 
Need Help
Show and Tell

7 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    Dgrooves 

    could you pls provide the sample data ? do you have a date table and filter the datetime?

    • Dgrooves's avatar
      Dgrooves
      Regular Visitor
      3 years ago

      I don't have a table I can share, Its just a basic table with date, customer number, duration.  If that helps. I appreciate your help

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        3 years ago

        you can provide some dummy data. Otherwise, it's difficult to provide you the proper solution.