The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello!
I have two cards both containing averages.
One is the average for response time to an inbound message. While the second card contains the average time to close/end the conversation.
These averages are based on the date range selected by the user.
However i was asked if i could remove the min/max values for each average prior to displaying the results.
Is this possible?
Heres how im calculating the initial response average
Solved! Go to Solution.
@Red_prov , Try like
AvgRespDir =
var _max = MaxX(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
var _min = Minx(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
return
AVERAGEX(filter(VALUES(Messages[ConversationID]),[ConversationInitialResponse]<> _max && [ConversationInitialResponse]<> _min ),[ConversationInitialResponse])
@Red_prov , Try like
AvgRespDir =
var _max = MaxX(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
var _min = Minx(VALUES(Messages[ConversationID]),[ConversationInitialResponse])
return
AVERAGEX(filter(VALUES(Messages[ConversationID]),[ConversationInitialResponse]<> _max && [ConversationInitialResponse]<> _min ),[ConversationInitialResponse])
User | Count |
---|---|
56 | |
54 | |
53 | |
47 | |
30 |
User | Count |
---|---|
175 | |
88 | |
69 | |
48 | |
46 |