Filter from a column using a card

[sharpedogs]

Hi, 

I have a list of services with Total Spend as per below. I am going to add this to my chart as a filter lits. I want the user to click on the E-Mail and then i want a card that shows the % of that services spend compared to the total spend. I know i should be using some sort of "unfilter" in my measure but i can't seem to figure out the syntext.

CARD - would show (20%)  when i click on e-Mail 

Service	Total spend
e-Mail	$100
Workstation	$50
Sharepoint	$150
Office 365	$200

[Greg_Deckler · Accepted solution]

@sharpedogs I believe:

Measure =
  VAR __Service = SUM('Table'[Total spend])
RETURN
  __Service / SUMX(ALL('Table'),[Total spend])

[amitchandak · Accepted solution]

@sharpedogs , Try a measure like

divide(sum(Table[Total spend]),calculate(sum(Table[Total spend]), all(Table)))

[Greg_Deckler · Accepted solution]

@sharpedogs I believe:

Measure =
  VAR __Service = SUM('Table'[Total spend])
RETURN
  __Service / SUMX(ALL('Table'),[Total spend])

[sharpedogs]

thats it.... the "All" function....