Forum Discussion

Frequent Visitor

9 years ago

Solved

HELP: DAX Formlula

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!

aymeric_kolan
9 years ago
I found:

Plati_Answered = calculate(distinctcount('DATA SVI_2'[InboundVoiceCalls_CallId]);FORMAT('DATA SVI_2'[CallAgentCommunicationDuration]; "General Number") > "0")

3 Replies

vanessafvg
Community Champion
9 years ago

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)
- aymeric_kolan
  Frequent Visitor
  9 years ago
  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
  - aymeric_kolan
    Frequent Visitor
    9 years ago
    I found:
    
    Plati_Answered = calculate(distinctcount('DATA SVI_2'[InboundVoiceCalls_CallId]);FORMAT('DATA SVI_2'[CallAgentCommunicationDuration]; "General Number") > "0")

Related content