Filter a table based on a measure value

[Anonymous]

Hello,

I have  two tables and two cards here. 

(I want to remove the total row in the second table how do I do that?)

Now I am trying to create additional table that are consist of column Service Provided and column Renewal but I want to filter it by Expiring or Expired separately. I have created a measure that filters it but it only works for the card 

Expiring = CALCULATE(COUNT('Vendor Data'[Service Provided]), FILTER('Vendor Data','Vendor Data'[Renewal] = "Expiring"))

and if i try to do it in a table it became like this

Do you guys know how can I do it in a table?

[amitchandak · Accepted solution]

@Anonymous , one way is is use visual level filter , measure is not blank.

Or have meausre like the example

sumx(filter(values(Table[end]), not(isblank([measure]))),[measure])

[Anonymous]

Thank you again Amitchandak 🙂