Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |