Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filtering in Dax functions

Hello All,

 

I have table where I am having data like below.

My requirement is I need to create a DAX logic where I can get the score for only team A 

 

 

TeamScore
A10
B20
C30
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Score only A measure: =
CALCULATE ( SUM ( 'Table'[Score] ), 'Table'[Team] = "A" )

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Score only A measure: =
CALCULATE ( SUM ( 'Table'[Score] ), 'Table'[Team] = "A" )