cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Divide a calculate column result between a measure

Hi,

I want to divide the time, obtained from a calculated column, between the number of tickets, obtained with a measure.

The Time is obtained with the following calculated column:

Time = var Resolve = CALCULATE(MIN(Historico[Index]);FILTER(HISTORICO;Historico[ID de incidencia]=earlier(Historico[ID de incidencia])&&Historico[EstadoInicial]="Resolved"))
return
if([Index]<Resolve;0;Historico[Tiempo Transicion])

And tickets are obtained with the following measure:
Ticktes = CALCULATE(DISTINCTCOUNT(Historico[ID de incidencia]))

Why I can´t simply create a measure like % = DIVIDE(Time;Tickets)? Is there a way to conduct the division?

Thank
1 ACCEPTED SOLUTION
Community Champion

I assume you want to create a new measure, correct? in your code

`` % = DIVIDE(Time;Tickets)``

you try to divide multiple values (column) by a scalar (measure), which obviously doesn't work. You have to aggregate [Time] first, try something like this:

`` % = DIVIDE(SUM('Historico'[Time]);[Tickets])``

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

1 REPLY 1
Community Champion

I assume you want to create a new measure, correct? in your code

`` % = DIVIDE(Time;Tickets)``

you try to divide multiple values (column) by a scalar (measure), which obviously doesn't work. You have to aggregate [Time] first, try something like this:

`` % = DIVIDE(SUM('Historico'[Time]);[Tickets])``

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

## Helpful resources

Announcements

#### 2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

#### Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors
Top Kudoed Authors