Forum Discussion

4 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    4 years ago

    hi,

    the problem is that in your  dax formula you are trying to compare a number with a text. 

    can ypu post the measure CurryShots[Total FG Made]?

  • justdoitabhishe's avatar
    justdoitabhishe
    New Member
    4 years ago
    Total FG Attempted = DISTINCTCOUNT(CurryShots[Shot ID])
    Total FG Made = calculate([total fg attempted], curryshots[outcome] = 1)
    • serpiva64's avatar
      serpiva64
      Solution Sage
      4 years ago

      are you sure curryshots[outcome] is a number? try with Value(curryshots[outcome])