Create a measure filtering by a calculated column

[Anonymous]

Hello,

I have a measure I already created:

Measure 1 = (MoM Change * .7) + (MoM Trailing Avg * .3)

And I want to use Measure 1 to perform calculations, depending on another filter.

The filters are by Severity, and I want to perform the following calculation:

Measure 2 =

If Severity = Sev 1 - Critical, then do Measure 1 * .4,

If Severity = Sev 2 - Major, then do Measure 1 * .3

etc...

Keep in mind, each product has at least one Severity value. For example, we can have the following:

Table 1

Product A | Sev 1 - Critical

Product B | Sev 3 - Minor

Product  C | Sev 4 - Trivial

Please help!

[Anonymous · Accepted solution]

Got the solution.

Rather than using the calculated column as a reference, I used the SELECTEDVALUE() function.