Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago
Solved

Calculate measure based field parameter selection

Hi all,

Please suggest how to calculate measure based field parameter selection

In this case I’m trying to switch between Budget or Forecast based on user selection

Field Parameter:

Scenario = {

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

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

}

Measure Used

Measure test =    (SUM(‘table’[Forecast])- SUM(' table’ [actual]))

 

 

 

Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You can try

    Variable Measure =
VAR InitialAmount =
    SWITCH (
        SELECTEDVALUE ( Scenario[Ordinal] ),
        0, SUM ( 'Table'[Budget] ),
        1, SUM ( 'Table'[Forecast] )
    )
VAR Result =
    InitialAmount - SUM ( 'Table'[Actual] )
RETURN
    Result

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    1 year ago

    You can try

    Variable Measure =
VAR InitialAmount =
    SWITCH (
        SELECTEDVALUE ( Scenario[Ordinal] ),
        0, SUM ( 'Table'[Budget] ),
        1, SUM ( 'Table'[Forecast] )
    )
VAR Result =
    InitialAmount - SUM ( 'Table'[Actual] )
RETURN
    Result