query to form a measure

[Anonymous]

hiii

i have created a calculated column to cal culate waiting tym what is the query to form a measure

waiting tym = MOD( ('Phone Call Data'[Disconnect Time]-'Phone Call Data'[Connect Time]-'Phone Call Data'[Hold Time]-'Phone Call Data'[Talk Duration]),60)

[harshnathani]

Hi @Anonymous ,

Pls share some sample data and expected output to help you better

Thanks

Harsh Nathani

[Fowmy]

@greeshma

Hi, can you check and let me know if the solution I provided worked for you please?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, Linkedin

[Anonymous]

no sorry its not the correct solution

[Fowmy]

@greeshma

Thanks for the feedback

[pranit828 · Accepted solution]

Hello @greeshma

use the following

waiting tym = 
MOD( 
    ( SELECTEDVALUE('Phone Call Data'[Disconnect Time]) - 
      SELECTEDVALUE('Phone Call Data'[Connect Time]) - 
      SELECTEDVALUE('Phone Call Data'[Hold Time]) -
      SELECTEDVALUE('Phone Call Data'[Talk Duration])
    )
    ,
    60
)

Did I solve your problem? Mark my position as a solution!

We appreciate your congratulations, press the thumbs up button !!

Best regards
Pranit

[Fowmy]

@Anonymous 

Use the following as measure

waiting tym = 
MOD( 
    ( MAX('Phone Call Data'[Disconnect Time]) - 
      MAX('Phone Call Data'[Connect Time]) - 
      MAX('Phone Call Data'[Hold Time]) -
      MAX('Phone Call Data'[Talk Duration])
    )
    ,
    60
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[mahoneypat]

Please try this expression.  If you don't want the total waiting time, you can use AVERAGEX instead to get average waiting time.

waiting tym =
DIVIDE (
    SUMX (
        'Phone Call Data',
        'Phone Call Data'[Disconnect Time] - 'Phone Call Data'[Connect Time] - 'Phone Call Data'[Hold Time] - 'Phone Call Data'[Talk Duration]
    ),
    60
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat