Basic Total Calculation for Helpdesk Call

[jdubbs57]

Hello,

First let me apologize. I realize my ask is very basic but cannot find the way forward. I am a former Tableau user attempting to convert to Power BI. The total formula/calulation is built into Tableau and im struggling on how to do this in Power BI. 

Ive attached a small sample of what data I have. Essentially I would like to calculate the total # of helpdesk calls by using the Ticket ID field. From there I can apply the new (totals) field to various slices of my data to break down the calls by month into different views. For example, # of calls by priority, call source, etc.

Appreciate any help you can provide.

[jdubbs57]

Thank you!! Now its time to watch the tutorials 🙂

[Anonymous · Accepted solution]

Assuming 'Ticket ID' is a unique the following measure will give you the total number of calls that can then be sliced / filtered as needed.

Total_calls= 
    COUNTROWS('Table')