cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ley
Helper I
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
Stachu
Community Champion
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!

View solution in original post

1 REPLY 1
Stachu
Community Champion
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 760x460.png

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.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors