Get a value from a specific characteristic in a colum

[Anonymous]

Hi I have a question which makes me crazy 😄 hope you can help me 

This is my table: 

employeeID	Points	Days
9	16	365
9	4	30
9	3	90
9	2	30

Now I am trying get the sum of points for each employee for a specific Day value. That means it should output 6 when I want to get the sum of points for the day value "30" (2+4) 

I created following measure but that did not work properly. 

IF(SELECTEDVALUE('Delay'[Days]) =30 ;SUM('Delay'[Points]);BLANK()))

Do you have any ideas? Thank you!

[Tahreem24]

@Anonymous ,

Or try using below measure:

Measure 2 = SUMX('Table',CALCULATE(sum('Table'[Points]),'Table'[Days]=30))

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Hi @Anonymous 

Your measure works fine when i tested. 

If your "Days" column is not in number format you need to add " around 30, i also noticed you seem to have one ) to many at the end. 

This is what I used: 

Measure = IF(SELECTEDVALUE('Table'[Days]) = 30; SUM('Table'[Points]);BLANK())

br

Adrian

[Tahreem24]

@Anonymous ,

Use the below Measure:

Measure = CALCULATE(sum('Table'[Points]),ALLEXCEPT('Table','Table'[Days]))

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Hi, this sums up all the values of 30, but does not differenciate between the employeeIDs. SO it outputs for every employee the same result. 

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

You need a measure as below:

Measure = CALCULATE(SUM('Table'[Points]),ALLEXCEPT('Table','Table'[Days]))

And you will see :

For the related .pbix file,pls click here.

Best Regards,
Kelly