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])...
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])
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])