cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Modify DAX for Field Parameters

Hi,

 

I have exisiting field parameter with slicer that works but I would to modify the dax so it will return values based on another field parameter slicer. However, I'm getting an error with the dax.

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

I'm not sure if my approach is correct but I would appreciate any help please @TheoC  @JoaoMarcelino 

qsmith83_0-1667159639518.png

 

 

Comparative Scen3 (field param) = 
VAR Comparative_Scenario_USD =
{
    ("Budget", NAMEOF('KPI USD'[KPI MTD Budget USD]), 0),
    ("Last Year", NAMEOF('KPI USD'[KPI MTD LY USD]), 1),
    ("2019", NAMEOF('KPI USD'[KPI MTD 2019 USD]), 2),
    ("Forecast", NAMEOF('KPI USD'[KPI MTD Forecast USD]), 3)
}

VAR Comparative_Scenario_LOCAL =
{
    ("Budget", NAMEOF('KPI'[KPI MTD Budget]), 0),
    ("Last Year", NAMEOF('KPI'[KPI MTD LY]), 1),
    ("2019", NAMEOF('KPI'[KPI MTD 2019]), 2),
    ("Forecast", NAMEOF('KPI'[KPI MTD Forecast]), 3)
}

RETURN
SWITCH(
    SELECTEDVALUE(ParamCurrency[ParamCurrency]),
    "USD", Comparative_Scenario_USD,
    "LOCAL", Comparative_Scenario_LOCAL
)

 

 

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , As of now field parameters can filter slicers of another field parameter. You can check and vote for an existing idea : https://ideas.powerbi.com/ideas/

Anonymous
Not applicable

@amitchandak - thanks for the feedback. That's a shame. I guess the alternative options could be using bookmarks or creating a table for the slicer selection and then creating measures using selected value.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors