Forum Discussion

aymeric_kolan's avatar
aymeric_kolan
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 ca...
  • aymeric_kolan's avatar
    aymeric_kolan
    9 years ago

    I found:

     

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

aymeric_kolan's avatar
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's avatar
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")