Need MIN, MAX, AVG on Measures in new table

[Anonymous]

I am in need of some assistance with finding the MIN, MAX, and AVG of measures that were created.

This table is grouped by Job Number.

The following columns  are all measures - Drafting, PM, PC, Loading, Shop Handle, Sop Supervision, Yard Handle.

The measure for Drafting = 

Drafting Act = CALCULATE([TotalHoursALL],'Labor Data'[Hours Type]="Indirect",'Labor Data'[Phase (groups)]="Drafting")/CALCULATE(SUM('Labor Data'[ActualHours]),'Labor Data'[Hours Type]="Direct")

Here are some of my other measures:

PM Act= CALCULATE([TotalHoursALL],'Labor Data'[Hours Type]="Indirect",'Labor Data'[Phase (groups)]="Project Manager")/CALCULATE(SUM('Labor Data'[ActualHours]),'Labor Data'[Hours Type]="DIrect")

Shop Handle Act = CALCULATE([TotalHoursALL],'Labor Data'[Hours Type]="Indirect",'Labor Data'[Phase (groups)]="Shop Handle")/CALCULATE(SUM('Labor Data'[ActualHours]),'Labor Data'[Hours Type]="DIrect")

I am trying to create an additional table that shows the Max, Min, and Average for each category - but I cannot use the measure I created to do so to get that information.

Any direction would be helpful! Thank you in advance!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the post below and use MINX, MAXX and AVERAGEX.

https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310#M138480

[Anonymous]

Thank you so much! I have been looking for days for a solution and finally decided post!