cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - July 2024

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

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors