Forum Discussion

mscantle's avatar
mscantle
Icon for Helper I rankHelper I
2 years ago
Solved

Power BI table with rows filtering a dataset

I have a dataset of values for academic performance of high school students in various subjects (Maths, English, Science, etc). Each student belongs to one or more key groups (eg Male, Female, Speci...
Tips and Tricks
  • mscantle's avatar
    mscantle
    2 years ago

    Thanks, but this doesn't solve the problem.

    I have ended up creating lots of measures and then arranging them in Cards as follows:

    The slicers then all work.

    I just can't help thinking this a very inefficient way of getting what I want.

ravsha85's avatar
ravsha85
Frequent Visitor
2 years ago

mscantle  Pls use Matrix Visual and let me know if you still face any issues

mscantle's avatar
mscantle
Icon for Helper I rankHelper I
2 years ago

Thanks, but this isn't quite what I need.

Here's a sample of the grades we collect for the students (we do this several times per year):

Here's a sample of the student group information we have:

I would like something that averages the grades for each group that looks like this:

However, I also want to slice it by date (2023a, 2023b, etc)

 

Sorry if this is way different to my original description, but if you can help, that would be amazing.