I have used the following measures for calculating the average tickets for 2020.
Go to Solution.
Try it like this.
Average Tickets =
VALUES ( 'Report Ticket'[Date].[Month] ),
CALCULATE ( COUNT ( 'Report Ticket'[Request ID] ) )
Or, if you want to keep the measures seperate your month count would look like this.
DISTINCTCOUNT ( 'Report Ticket'[Date].[Month] ),
KEEPFILTERS ( 'Report Ticket'[Date].[Date] <= TODAY () )
View solution in original post
Thanks @jdbuchanan71 . It worked...
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.