Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have measure which I have created to do average of time. I am displaying this value in a matrix. This is how the matrix looks -
Now here when I add the measure measureAverageHandle, I get the agents which have no values as well. I want to show just those agents which have that value.
Here if I remove the measure I just get Agents which has value. I have tried adding visual filter is not blank but that does not work.
measureAverageHandle is a Text type and cannot be converted to time format.
AgentEnterpriseName belongs to TableA and measureAverageHandle is based on TableB. Both these table have relationship via AgentId
measureAverageHandle is calculated as below -
measureAverageHandled = FORMAT((SUM(TableB[calculatedTalkTime])/SUM(TableB[CallsHandled]))/86400, "hh:mm:ss")
Hi @ashaikh
It seems the hours are more than 24,it could not be changed to time format.Please refer to this post to get the time data type.Sample data and expected output will be helpful to provide an accurate solution.
Regards,
@v-cherch-msft I dont want to get into Time datatype. What I am looking to do is get rid of agent name which have blank value.
Try:
measureAverageHandled = IF(SUM(TableB[calculatedTalkTime] > 0 ; FORMAT((SUM(TableB[calculatedTalkTime])/SUM(TableB[CallsHandled]))/86400, "hh:mm:ss"); BLANK())
Also make sure that you have show items with no data turned off:
@tex628 Are you creating here a calculated column or a measure?
Also what I exactly need is filter the agent is there a way I can do that in the filter. Instead of this filter you are showing.
Measure,
If you just want to filter away agents with no data, put a filter in visual filters:
A "Is not blank" filter should remove the blank rows for the visual
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
59 | |
58 |