How to get summary table and filter by slicer

[neoneo]

Help me please.

As below table

Animal    First Grade    Second Grade    Third Grade
Cat                   B                    A                    A
Rat                   A                    A                    A
Bird                   D                    C                    A
Cat                    E                    B                    B
Rat                    A                    B                    B
Bird                    B                    A                    A
Cat                    C                    B                    C
Rat                    C                    E                    D
Bird                    E                    D                    C

How can i create summary and line chart on page (and can use slicer to filter by Group )

Grade      First      Second      Third
A               2               3               4
B               2               3               2
C               2               1               2
D               1               1               1
E               2               1               0

Sorry, My Englis isn't that good.

[ryan_mayu]

@neoneo 

is this what you want?

please see the attachment.

[neoneo]

I want count grade from table data.

[amitchandak · Accepted solution]

@neoneo , You have to create a common grade table

Grade =distinct(union(all(Table[First Grade]),all(Table[Second Grade]),all(Table[Third Grade])))

Join with all three columns now will active, another one will be inactive //Assume active is First Grade

Count is

In table visual table grade from grade table and these measures

Count First Grade = count(Table[First Grade])
Count Second Grade = calculate(count(Table[Second Grade]), userelation(Table[Second Grade], grade[First Grade]))
Count Third Grade = calculate(count(Table[Third Grade]), userelation(Table[Third Grade], grade[First Grade]))

refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://www.youtube.com/watch?v=e6Y-l_JtCq4