Replace Value in measure based on Active Category/Filter

[rtaylor]

Hello,

I have a measure with calculates a budget.  I want to replace the expression with another, but only when a certain category is used. Please see below the example. Thanks in advance.

Budget Calculation(Matrix Visual)

Category First Measure   Category 2nd Measue            Desired Result

A 500                                 A  7000                                 A 500

B 600                                 B  7000                                  B 7000

C 100                                 C  7000                                  C 100

In this instance only category b will be replaced. Any help would be greatly appreciated.

[jdbuchanan71 · Accepted solution]

Hello @rtaylor 

I am assuming your Category is in a seperate column.

Desired Result = IF ( SELECTEDVALUE ( Table[Category] ) = "B", [Category First Measure], [Category 2nd Measure] )

[rtaylor]

Thanks so much. I knew it was something simple.