Forum Discussion

dana1's avatar
dana1
Frequent Visitor
9 years ago

calculate

hello :)

 

I have a column of call ID and another column which contains the caller ID of the caller.
I try to calculate the number of calls per user by their ID.
In addition, I want to make a filter that will filter only the 120 callers who make the most calls.
I needed it in measure, I tried in several possible ways but failed.
the ticketnumber is the call id and the institutID is the caller ID-

Suggestions?
Need Help

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi dana1,

     

    You can create two measures:

    number of calls =
CALCULATE (
    DISTINCTCOUNT ( 'Call table'[ticketnumber] ),
    ALLEXCEPT ( 'Call table', 'Call table'[instituteID] )
)

Rank = RANKX(ALL('Call table'),[number of calls],,DESC,Dense)

    Then, to filter the 120 callers who make the most calls, under visual level filters pane, set "Rank<=120"

     

    Best regards,
    Yuliana Gu

    • dana1's avatar
      dana1
      Frequent Visitor
      9 years ago

       hi v-yulgu-msft

       

      thank u, it works..

      but now im trying to filter it by months in the visual but the data do not change according to the choice of the months..

      you can see in the picture that there is no change in the total number of calls when i choose specific months and when i choose an entire year.

       

       

       

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi dana1,

         

        If you want to use the date slicer to filter visual, please consider below two conditions:

        • The date column is an existing column in source table (caller table)
        • Or an other table which contains this date column has a relationship with caller table.

         

        Regards,
        Yuliana Gu

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi dana1,

     

    Have you achieved your requirement? If yes, would you please mark the corresponding reply as an answer or share your solution so that it can benefit more users?

     

    Regards,
    Yuliana Gu