Forum Discussion

HishamAT's avatar
HishamAT
Helper II
3 years ago
Solved

filter rows using letters and numbers

I have a table contains on the following data, my question is how to filter and calculate the rows numbers using Grade as filter.

for example, Grand Total of rows = Total of rows if Grade is 20 + Total of rows if Grade is 30 + Total of rows if Grade is C + Total of rows if Grade is E and so on...

Token

Grade

100

20

200

30

300

30

400

20

500

C

1000

C

1200

E

1300

E

 

 

Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    HishamAT 
    Total Token =
    CALCULATE (
    SUM ( 'Table Y'[Token] ),
    ALLEXCEPT ( 'Table Y', 'Table Y'[Grade] )
    )

     

    HishamAT  If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!

     

1 Reply

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    HishamAT 
    Total Token =
    CALCULATE (
    SUM ( 'Table Y'[Token] ),
    ALLEXCEPT ( 'Table Y', 'Table Y'[Grade] )
    )

     

    HishamAT  If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!