Modify DAX for Field Parameters

Anonymous — Sun, 30 Oct 2022 19:56:01 GMT

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

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 )

Re: Modify DAX for Field Parameters

amitchandak — Mon, 31 Oct 2022 04:17:54 GMT

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/

Re: Modify DAX for Field Parameters

Anonymous — Mon, 31 Oct 2022 05:30:32 GMT

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.

topic Re: Modify DAX for Field Parameters in DAX Commands and Tips

Modify DAX for Field Parameters

Re: Modify DAX for Field Parameters

Re: Modify DAX for Field Parameters