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? 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yay! Thank you Greg! It worked on the second try.