How to sum values in a row filtered by name

[Anonymous]

How can I sum the value from each column filtered by the name of teh person

I need that in the last column the result value is the the sum of the 5 rows (P01 + P02 + P03 + P04 + P05) the first value should be 0 but I get as a result 4486

[v-kelly-msft]

Hi @Anonymous，

Based on my test,it should work fine.

What's your measure for value?Could you pls upload your .pbix file to onedrive business and share the link with us?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[pranit828]

HI @Anonymous 

Measure = SELECTEDVALUE([P01]) + SELECTEDVALUE([P02]) + SELECTEDVALUE([P03]) + SELECTEDVALUE([P04]) + SELECTEDVALUE([P05])