Averages in a summary view per type/category?

[sakhan1021]

Hi Community!

This is my first post , embarking on my journey in Power BI/DAX.  I am working with work order data  that i've pulled into my model in PBI desktop. 

The two columns below represent a total number of est. hours (WO_NUM1) for each year.  There are two measures I have that essentially apply a filter via the following measure on this data:

Filter 2018 Completion = CALCULATE(SUM('Track-It Static 7-7-2018'[WO_NUM1]), 'Track-It Static 7-7-2018'[Complete Date]="2018")

Calc Full 2018 = CalculatedMeasures[Filter 2018 Completion] * 2

The two above essentially give me the total I am expecting in the table below.  However, what I ultimately need is an Average of these three values and display in a row per "TYPE".   I hope this makes sense.  Again, very new to DAX/Power BI. 

Any thoughts on how I might achieve this?  

[Greg_Deckler]

Sorry, the average of what 3 numbers exactly?

Welcome!

[sakhan1021]

Hello, any ideas on how I might achieve this?

[parry2k]

Can you share what is expected result you are looking for?

[sakhan1021]

Thanks.  Yes, I am looking to achieve the following -

return a single row in a table that takes each type and outputs the average of the three years.  My table has many rows for each type similar to what I show in the original post.  so imagine different values in type for 2016, 2017, 2018 and the values in wo_num1 associated with each year.  

I am trying to return a single row per type with the average of the three values under WO_NUM1.

[parry2k]

would you mind showing the expected result. like put some example in excel sheet and explain with data.

[sakhan1021]

DATA TABLE
TYPE	YEAR	HOURS
System a	2018	200
System a	2017	500
System a	2016	1000
system b	2018	50
system b	2017	200
system b	2016	400
system c	2018	130
system c	2017	250
system c	2016	560
TYPE	AVG
System a	n
systemb	n
system c	n

I'd like to return the what you see in the grid where just TYPE and AVG are the columns; one row per 'Type'

[parry2k · Accepted solution]

Drop type and hours in a table visual, and next to drop menu in hours, change aggregation method to average. This drop down option is where you drop column in the values section.

[sakhan1021]

Hello @Greg_Deckler

Sorry, that would be the values listed under column 'WO_NUM1'.  The example is just a subset of rows.  In my current table, there are 3 rows (for each yr 2016/17/18) for each system.  I am looking to get a table that gets me an average of the 3 values on a single line - i.e. system.  I hope I am making sense. Cheers!