Forum Discussion
sharpedogs
Advocate II
Advocate IIFilter from a column using a card
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 t...
sharpedogs I believe:
Measure = VAR __Service = SUM('Table'[Total spend]) RETURN __Service / SUMX(ALL('Table'),[Total spend])sharpedogs , Try a measure like
divide(sum(Table[Total spend]),calculate(sum(Table[Total spend]), all(Table)))
Greg_Deckler
Community Champion
Community Championsharpedogs I believe:
Measure =
VAR __Service = SUM('Table'[Total spend])
RETURN
__Service / SUMX(ALL('Table'),[Total spend])
sharpedogsAdvocate II
Advocate IIthats it.... the "All" function....