HELP: DAX Formlula

[aymeric_kolan]

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!

[vanessafvg]

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]

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 · Accepted solution]

I found:

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