Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Can you help me to create DAX formula (mesure)
I would like to identify distinct value (InboundVoiceCalls_CallId) with conditions.
table name: DATA SVI_2
description: For each ID, I can have few rows with different filters
colums used:
- InboundVoiceCalls_CallId
- CallAgentCommunicationDuration
- CallDisconnectionStatus
Conditions:
- CallAgentCommunicationDuration <> "0" AND CallDisconnectionStatus = "0"
I think in SQL is like :
SELECT disctint (InboundVoiceCalls_CallId)
FROM DATA SVI_2
WHERE CallAgentCommunicationDuration <> "0"
AND CallDisconnectionStatus = "0" Thank you for your help!
Solved! Go to Solution.
I found:
Plati_Answered = calculate(distinctcount('DATA SVI_2'[InboundVoiceCalls_CallId]);FORMAT('DATA SVI_2'[CallAgentCommunicationDuration]; "General Number") > "0")
I think in SQL is like :
SELECT disctint (InboundVoiceCalls_CallId)
FROM DATA SVI_2
WHERE CallAgentCommunicationDuration <> "0"
AND CallDisconnectionStatus = "0" Thank you for your help!
i think,
create a calculated measure
measurename = calculate(distinctcount(InboundVoiceCalls_CallId), CallAgentCommunicationDuration <> 0 && CallDisconnectionStatus = 0)
Proud to be a Super User!
Thank you vanessafvg but it doesn't work.
Plati_Answered = calculate(distinctcount('DATA SVI_2'[InboundVoiceCalls_CallId]);'DATA SVI_2'[CallAgentCommunicationDuration]<>"0.00:00:00")
Power Bi said "use fonctional VALUE or FORMAT to convert values"
For informations:
- InboundVoiceCalls_CallId is text
- CallAgentCommunicationDuration is time
I found:
Plati_Answered = calculate(distinctcount('DATA SVI_2'[InboundVoiceCalls_CallId]);FORMAT('DATA SVI_2'[CallAgentCommunicationDuration]; "General Number") > "0")
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |