cancel
Showing results for
Did you mean:
Highlighted
Helper III

## Measure that Repeats The Measure (Averare) as a Target Colum

I am looking for a way where my total average for a category, becomes my target for a specifit task and added as a new column using a meausement in my Matrix Table.

In my matrix table i have the tasks, with an IDs and Time (Avg) it took to complete a project.  The Time is base on another average from a table (Time Measure is just basic Average, "Time=Calculate(Average(Table1[Time]))" )

I am looking to add the "Target (Average Per Task)" column, which is my task Average, so i need it to repeat for each ID.  The measurements i have used to accoumplish this have provide me the same value as my Time Average.

What I have Tried

Target Avg = CALCULATE(AVERAGE(Table1[Time]))

 Task ID Time Target (Average Per Task) 1-2 M100 5 6.33 1-2 M200 4 6.33 1-2 M300 10 6.33 1-2 M301 5 6.33 2-3 M100 4 4.33 2-3 M125 3 4.33 2-3 M301 6 4.33 3-4 M100 8 6 3-4 M125 4 6

Any Assistance will be greatly appreciated!!! Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

Hi @BJR ,

Try this measure:

Riacrdo

Proud to be a Super User!

3 REPLIES 3
Highlighted
Super User III

Hi @BJR ,

Try this measure:

Riacrdo

Proud to be a Super User!

Highlighted
Helper III

Thank you for quick response.  It did work with some changes that i made.  The measurement you provided does make the number static for each task, but it takes the whole average in my table, ignoring any filters i have in my visual.  What i did i added the rest of the filter to the ALLEXECEPT Calculation.  Unless there is a different way to include them.

Thanks Again for quick response. I am new to PBI and still learning

Highlighted
Super User III

@BJR ,

You should include the columns on ALLEXCEPT functions that are part of a combination for an exception. If you miss at least 1 column, it will replicate until the combination is done.

Ricardo

Proud to be a Super User!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors