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  you can try to create a Summarized table based on the Inputs you have 

 

SummaryTable =
SUMMARIZE (
'StudentTable',
'StudentTable'[KeyGroup],
"Maths Avg", AVERAGE ( 'StudentTable'[Maths] ),
"English Avg", AVERAGE ( 'StudentTable'[English] ),
"Science Avg", AVERAGE ( 'StudentTable'[Science] )
)

 

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

Thanks ravsha85 - this looks like a good solution. How would I add multiple KeyGroups?

  • ravsha85's avatar
    ravsha85
    Frequent Visitor
    2 years ago

    Based on your table structure I have created a sample , you could use the drill down approach to see it based on each keygroup

     

     

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

      Sorry, but where is this visualization?

      • ravsha85's avatar
        ravsha85
        Frequent Visitor
        2 years ago

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