cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sakhan1021 Frequent Visitor
Frequent Visitor

Averages in a summary view per type/category?

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?  

 

 

avg needed.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Averages in a summary view per type/category?

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.






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





8 REPLIES 8
Super User
Super User

Re: Averages in a summary view per type/category?

Sorry, the average of what 3 numbers exactly?

 

Welcome!


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

sakhan1021 Frequent Visitor
Frequent Visitor

Re: Averages in a summary view per type/category?

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! 

sakhan1021 Frequent Visitor
Frequent Visitor

Re: Averages in a summary view per type/category?

Hello, any ideas on how I might achieve this?

Super User
Super User

Re: Averages in a summary view per type/category?

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






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





sakhan1021 Frequent Visitor
Frequent Visitor

Re: Averages in a summary view per type/category?

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.

Super User
Super User

Re: Averages in a summary view per type/category?

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






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





sakhan1021 Frequent Visitor
Frequent Visitor

Re: Averages in a summary view per type/category?

DATA TABLE  
TYPEYEARHOURS
System a2018200
System a2017500
System a20161000
system b201850
system b2017200
system b2016400
system c2018130
system c2017250
system c2016560
   
TYPEAVG 
System an 
systembn 
system cn 

 

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

Highlighted
Super User
Super User

Re: Averages in a summary view per type/category?

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.






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 210 members 2,560 guests
Please welcome our newest community members: