Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I have used the following measures for calculating the average tickets for 2020.
Solved! Go to Solution.
Try it like this.
Average Tickets =
AVERAGEX (
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.
NumofDistinctDates =
CALCULATE (
DISTINCTCOUNT ( 'Report Ticket'[Date].[Month] ),
KEEPFILTERS ( 'Report Ticket'[Date].[Date] <= TODAY () )
)
Try it like this.
Average Tickets =
AVERAGEX (
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.
NumofDistinctDates =
CALCULATE (
DISTINCTCOUNT ( 'Report Ticket'[Date].[Month] ),
KEEPFILTERS ( 'Report Ticket'[Date].[Date] <= TODAY () )
)
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |