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 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 |
| $100 | |
| Workstation | $50 |
| Sharepoint | $150 |
| Office 365 | $200 |
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)))
3 Replies
- Greg_Deckler
Community Champion
sharpedogs I believe:
Measure = VAR __Service = SUM('Table'[Total spend]) RETURN __Service / SUMX(ALL('Table'),[Total spend])
sharpedogsthats it.... the "All" function....
- amitchandak
Super User
sharpedogs , Try a measure like
divide(sum(Table[Total spend]),calculate(sum(Table[Total spend]), all(Table)))