Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Snagalapur
Helper IV
Helper IV

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
 
ErrorSnagalapur_0-1746011589334.png

 

1 ACCEPTED SOLUTION
mh2587
Super User
Super User

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

Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



View solution in original post

1 REPLY 1
mh2587
Super User
Super User

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

Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.