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

Categoría de prorrateo por día

Necesito ayuda para prorating tareas horas a día (Horas diarias). Necesito que esto sea una medida y no una columna calculada. Estoy bastante seguro de que estoy complicando demasiado esto y es bastante simple.

TareaDíaHoras totalesHorario diario
A1/1/2084
A1/2/2084
B1/1/2022
2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hola @shep123 ,

Compruebe la siguiente medida.

Measure = SELECTEDVALUE('Table'[Total Hours])/CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Task]))

2.PNG

Saludos

Jay

Equipo de Apoyo Comunitario _ Jay Wang

Si este post ayuda,entonces por favor considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User IV
Super User IV

@shep123, intente una medida como

divide(calculate(max(Table[Total Hours]),allexcept(Table[Task])),calculate(count(Table[Total Hours]),allexcept(Table[Task])))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Kudoed Authors