topic Calculate average time per maschine and per task in DAX Commands and Tips

Calculate average time per maschine and per task

JM94 — Thu, 13 Jan 2022 17:08:15 GMT

Hi there

I have just started my Power BI journey. I am trying to calculate the average time a specific maschine needed to complete a specifict task in order to compare it with the planned data.

In the screen shot below you can see my sample data, which includes:

- 5 different Maschine types (A, B C, D an E)

- 3 different Tasks (Nr 1, 2 and 3)

- Time needed for completing the task

Since there are many more maschine types and tasks in my real data set, I am looking for a way to build a table or a matrix, where I do not have to manually write the reffered machine ( = "Maschine A") or task, into the function. Any ideas how to do that?

Thanks in advance!

Re: Calculate average time per maschine and per task

ValtteriN — Thu, 13 Jan 2022 19:03:55 GMT

Hi,

Since measures work using current filter context a basic average measure should do what you want:

Example data:

Dax:

AverageTime = AVERAGE(MachineAverage[Time])

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Re: Calculate average time per maschine and per task

smpa01 — Thu, 13 Jan 2022 19:09:48 GMT

JM94 use the following measure

Avg by Maschine and task = CALCULATE ( AVERAGE ( tbl[Time] ), ALLEXCEPT ( tbl, tbl[Maschine], tbl[Task Nr.] ) )