Forum Discussion

kosmo's avatar
kosmo
Regular Visitor
8 years ago

Need Help with Aggregation.

Post is de-identified.   I'm new to PowerBI and need some help using aggregation in visualizations. I have three tables, AY (academic year), StudentList, and Volumes.  They are set up as below:   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

To answer your first question, yes you likely need a measure to calculate what you're looking for.  Using the Implicit measures (similar to what you would do with a standard pivot table) is not best practice, and doesn't even scratch the surface of what Power BI can do.

 

Can you provide what results you WANT to see in the table?  We can help you write the measure, but we need to better understand what you're trying to calculate.

 

To answer your 2nd question, Power BI is not the solution if you want to batch/automate reports for different students on a separate page.  You should look into using SSRS for that.

kosmo's avatar
kosmo
Regular Visitor
8 years ago

Thanks ChrisHaas!

 

I'm looking for the following table with an average Volume per ClassYear:

 

image.png

  • kosmo's avatar
    kosmo
    Regular Visitor
    8 years ago

    So I guess ot rephrase, each student is a member of a class. I want to aggregate the volumes for each class member and average that number year and per month.

     

    Each student would be on a difference subspecialty each month. In the end, I want to see something giving me the ability to see the average R1 student's volume in a year, in a month, and in a particular subspecialty.