Solved: Filtering in Dax functions

Anonymous · ‎12-04-2022

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

Jihwan_Kim · ‎12-04-2022

Hi,

Please check the below picture and the attached pbix file.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎12-04-2022

Hi,

Please check the below picture and the attached pbix file.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Filtering in Dax functions