Solved: Filtering in Dax functions

Sathvik123 · ‎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.

Go to My LinkedIn Page

View solution in original post

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.

Go to My LinkedIn Page

Filtering in Dax functions