cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

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
Community Champion

Hi @Anonymous ,

Try this measure:

Riacrdo

Proud to be a Super User!

3 REPLIES 3
Community Champion

Hi @Anonymous ,

Try this measure:

Riacrdo

Proud to be a Super User!

Anonymous
Not applicable

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

Community Champion

@Anonymous ,

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

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors