Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Card trouble - need a DAX solution

Need help with a DAX formula. I am trying to add a filter to a card to achieve "Blank" cards when the condition is not met.  The condition is that 5 players or more must play in order for the card to...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - 

    5 or more measure =
  VAR __Team = MAX([Team])
  VAR __Sport = MAX([Sport])
  VAR __5orMore = IF([# of players] >=5,1,0)
RETURN
  IF(__5orMore,[WeightedAverage],BLANK())

    Assumes a WeightedAverage measure. Do you need help with that as well? 

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

Anonymous , Try like

Measure =
var _dist =CALCULATE(DISTINCTCOUNT([PlayerID]))
return
SUMX(FILTER(Summarize(Table1,Table1[Team] ,Table1[Sport],"_1",_dist, "_2",SUMX(Table,[PlayerScore] * [Weight]),"_3",SUMX([Weight])),[_1]_dist>15),divide([_2] /[_3] ))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unfortunately I could not get this to work. Thank you for the reply though.