Forum Discussion

sharpedogs's avatar
sharpedogs
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Filter 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...
DAX
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    sharpedogs I believe:

    Measure =
  VAR __Service = SUM('Table'[Total spend])
RETURN
  __Service / SUMX(ALL('Table'),[Total spend])
  • amitchandak's avatar
    amitchandak
    6 years ago

    sharpedogs , Try a measure like

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

sharpedogs , Try a measure like

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