Forum Discussion
Average by Group
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
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
4 Replies
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
