Add DAX measure result to specific category

[BryanDAX345]

Need help with adding the result of a DAX measure into a Specific Category.

For Example:

DAX result = 50

I need to add the DAX result to category E

Category	Original Values	Desired Result
A	76	76
B	13	13
C	87	87
D	52	52
E	54	104
Total	282	332

The DAX result is not related to the category, therefore when I add the DAX measure to the Original values, it adds 50 to all the categories but I need this to be added to Category E.
I tried using an if statement but I get an incorrect Total value 
@daxdaxdax @PowerBI @daxdax @dax 

[Ashish_Mathur]

Hi,

Write this measure

DR = if(min(Data[Category])="E",[original values]+[DAX result],[original values])

Hope this helps.

[BryanDAX345]

Thanks but this does not return the correct value for the total.

It returns the same total as the sum of Original Value.

[Irwan]

hello @BryanDAX345 

please check if this accomodate your need.

Desired Result =
IF(
    'Table'[Category]="E",
    'Table'[Original Values]+'Table'[DAX result],
    'Table'[Original Values]
)

Plot your value in table visual (DAX result is in measure form).

Hope this will help you.

Thank you.

[BryanDAX345 · Accepted solution]

This was useful but Im not able to use a calculated column since my dataset is more complex than just those 5 categories.
I was able to make it work by introducing a SUMX to your formula. Thanks!

New Value = SUMX('Table', IF('Table'[Category] = "E", 'Table'[Original Value] + [Measure], 'Table'[Original Value] ))