calculate

[dana1]

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?

[v-yulgu-msft]

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

[v-yulgu-msft]

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]

 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]

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