How to change the field value by using DAX

[KH_Mike]

Hi All,

Right now I create a table like below. Those fields are in the Table already. I would like to change the value when Table[Cat] = A and Table[Sub-Cat] = CC  to Table[Sub-Cat] = BB. Is it possible to acheive it by just by using DAX formalar (Measure)?

Before

Cat	Sub-Cat	sum(Volume)
A	AA	0
A	BB	1
A	CC	2
B	AA	3
B	BB	4
B	CC	5
C	AA	6
C	BB	7
C	CC	8

After

Cat	Sub-Cat	sum(Volume)
A	AA	0
A	BB	3
B	AA	3
B	BB	4
B	CC	5
C	AA	6
C	BB	7
C	CC	8

[Jihwan_Kim]

Volume Total by the condition : =
SWITCH (
TRUE (),
SELECTEDVALUE ( Categories[Cat] ) = "A"
&& SELECTEDVALUE ( Sub_Categories[Sub-Cat] ) = "CC", BLANK (),
SELECTEDVALUE ( Categories[Cat] ) = "A"
&& SELECTEDVALUE ( Sub_Categories[Sub-Cat] ) = "BB",
CALCULATE (
SUM ( Data[sum(Volume)] ),
Categories[Cat] = "A",
Sub_Categories[Sub-Cat] = "BB"
|| Sub_Categories[Sub-Cat] = "CC"
),
SUM ( Data[sum(Volume)] )
)

Link to the sample pbix file 

[amitchandak]

@KH_Mike , I DAX you have to create a new column

Sub Cat New =

if([Cat]= "A" && [Sub Cat] ="CC", "BB", [Sub Cat])

[KH_Mike]

Hi @amitchandak @Jihwan_Kim

Is it possible to do it in "Measure" instead of adding new column / create new table behind? Thank you.

[Jihwan_Kim]

Hi,

Please try the below measure.

The columns that are refered in the measure are from the same table.

Volume Total by the condition : =

SWITCH (

TRUE (),

SELECTEDVALUE ( Data[Cat] ) = "A" && SELECTEDVALUE ( Data[Sub-Cat] ) = "CC", BLANK (),

SELECTEDVALUE ( Data[Cat] ) = "A" && SELECTEDVALUE ( Data[Sub-Cat] ) = "BB",

CALCULATE (

SUM ( Data[sum(Volume)] ),

FILTER( ALL(Data), Data[Cat] = "A" &&

Data[Sub-Cat] in { "BB","CC"})

),

SUM ( Data[sum(Volume)] )

)