Forum Discussion

HishamAT's avatar
HishamAT
Icon for Helper II rankHelper 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 + To...
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!!

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper 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!!