Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago
Solved

Measure calculation based field parameter selection

Hi,

Please suggest how to mitigate error which i'm facing with measure-based field parameter selection

 

Field Parameter:

Scenario = {

    ("sum of Budget", NAMEOF('MEASURES_TABLE'[FY Forecast]), 0),

    ("sum of Forecast", NAMEOF('MEASURES_TABLE'[FY Budget]), 1)

}

 

Measure text =
VAR InitialAmount =
SWITCH (
        TRUE(),
        SELECTEDVALUE('Scenario'[Scenario]) = 0, [FY Budget],
        SELECTEDVALUE('Scenario'[Scenario]) = 1, [FY Forecast],
        BLANK() // default value if no condition is met
    )
VAR Result = InitialAmount - SUM('Table'[actual_op])
RETURN
    Result
 
Error: 

 

Need Help
  • mh2587's avatar
    mh2587
    1 year ago
    Measure Text = //Try this
VAR InitialAmount =
    SWITCH (
        SELECTEDVALUE('Scenario'[Name]),
        "sum of Budget", [FY Budget],
        "sum of Forecast", [FY Forecast],
        BLANK()
    )
RETURN
    InitialAmount - SUM('Table'[actual_op])

1 Reply

  • mh2587's avatar
    mh2587
    Super User
    1 year ago
    Measure Text = //Try this
VAR InitialAmount =
    SWITCH (
        SELECTEDVALUE('Scenario'[Name]),
        "sum of Budget", [FY Budget],
        "sum of Forecast", [FY Forecast],
        BLANK()
    )
RETURN
    InitialAmount - SUM('Table'[actual_op])