cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qsmith83
Responsive Resident
Responsive Resident

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

@qsmith83 , 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/



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

@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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors