Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
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 = AVERAGEX(VALUES(Table1[Task]),CALCULATE(AVERAGE(Table1.Time])))
Target Avg = CALCULATE(AVERAGE(Table1[Time])AllSELECTED(Table1.[Task])

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

 

TaskAverage Per Task
1-26.33
2-34.33
3-46.00

 

TaskIDTimeTarget (Average Per Task)
1-2M10056.33
1-2M20046.33
1-2M300106.33
1-2M30156.33
2-3M10044.33
2-3M12534.33
2-3M30164.33
3-4M10086
3-4M12546


Any Assistance will be greatly appreciated!!! Thanks,

 

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Try this measure:

 

Avg = CALCULATE(AVERAGE('Table'[Time]); ALLEXCEPT('Table';'Table'[Task]))
 
Riacrdo

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Try this measure:

 

Avg = CALCULATE(AVERAGE('Table'[Time]); ALLEXCEPT('Table';'Table'[Task]))
 
Riacrdo

 



Did I answer your question? Mark my post as a solution!

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.

Avg = CALCULATE(AVERAGE('Table'[Time]), ALLEXCEPT('Table';'Table'[Task],'Table';'Table'[Date],'Table';'Table'[Program],'Table';'Table'[Task]'Table';'Table'[Type]))

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

@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.

 

Glad it helped you.

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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