Average by Group

[JMWDBA]

I am going to start this off by saying that I definitely think I am overthinking this and its probably very simple.  So from the attached file, what I need to do is:

• Get the average months to completion of all with an [Academic Level] equal to Undergraduate
  • Then average months to completion of those undergraduate students by their [Military/Civilian] so average for Civilians and average for Military
• Get the average months to completion of all with an [Academic Level] equal to Graduate
  • Then average months to completion of those graduate students by their [Military/Civilian] so average for Civilians and average for Military

I would like to create "Cards" in Power BI to show each of these elements.

File: https://drive.google.com/file/d/0BxvqEMoNpMLiMEVPNDdZOTBsalk/view?usp=sharing 

[fhill · Accepted solution]

How's this as one possible solution (as i'm sure there's many wants to get the same answers.)  I have 2 seperate 'Multi-Row Cards' with Months to Complete set to 'Average'.  I've manually added the Title's, made them a good size, and removed the default Category Labels...?  The 2nd Multi-Row card's Visual Filters are reversed...

FOrrest

[fhill]

P.S.  Got a little boarded...  Did you happen to notice your sample data has very little overlap between Civilian and Military Degress?

[JMWDBA]

Maybe I should have created a larger sample data.  The actual data set has 3300 plus graduates in it and there is a lot of overlap. 

[fhill]

Hahaha, I assumed so, just thought it was a funny finding. 😎