Multiplying measure against fixed time

[YcnanPowerBI]

Hello community,

I have a measure that counts number of tickets processed**1 Tickets Created = CALCULATE(COUNT(Append1[Ticket Created]))**

I need to mutiply that against a fxed time value, ie. 00:05:00 or 5 minutes.  Help please......

[SivaMani]

@YcnanPowerBI , Can you elaborate more on the requirements?

Please post a sample data and output expected for a quick solution

[YcnanPowerBI]

Hi, Sorry for not being more clear.  Hope this helps. 

Here is a screenshot of expected results.  1 Tickets Created is an output of CALCULATE(COUNT(Append1[Ticket Created]))  In this example I multipied that against 5 minutes

1 Tickets Created	Total Time
4	0:20:00
2	0:10:00
6	0:30:00
8	0:40:00
1	0:05:00

[SivaMani · Accepted solution]

@YcnanPowerBI , try this in a measure

Total Time = FORMAT(TIME(0,[1 Tickets Created] * 5,0),"hh:nn:ss")

[YcnanPowerBI]

Worked great! Thank you for your time!

[SivaMani]

Glad that it worked, cheers!