topic Re: How to use DAX formula SELECTEDVALUE with Field Parameters in DAX Commands and Tips

How to use DAX formula SELECTEDVALUE with Field Parameters

AdamMetz23 — Mon, 27 Feb 2023 09:33:10 GMT

Dear Power BI community,

I would like to ask for your help as I am trying to use DAX formula SELECTEDVALUE based on field parameters, however it is not doable based on the following error message:

IF user selects between two value the (Amount USD & Amount LCL) the calculation should be changing based on that:

DAX formula :

Field Parameter:

Visualization selection for Amount USD & Amount LCL:

Would it be possible for someone to help how to change the DAX formula SELECTEDVALUE part to make it work?

Thank you for your advice in advance.

Wishing you a wonderful date.

Adam

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

andhiii079845 — Mon, 27 Feb 2023 09:39:43 GMT

One question: Why it is important to use field parameters instead of a regular table / calculated table?

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

AdamMetz23 — Mon, 27 Feb 2023 09:53:44 GMT

Thank you Andhi for your quick reply.

Actually the main reason for that is that this was the only way (based on my knowledge) how I could dynamically change the column chart visualization Y axis between amount usd and amount lcl based on the field parameter selection:

Is it inefficient to do so?

Thank you,

Adam

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

andhiii079845 — Mon, 27 Feb 2023 10:04:16 GMT

Can you perhaps upload a example file without sensitve datas?
Other post to field parameters
It seems to be possible. Perhaps try first to access only to the field parameter value?

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

andhiii079845 — Mon, 27 Feb 2023 12:31:44 GMT

What was the solution now in your case ? 🙂

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

AdamMetz23 — Mon, 27 Feb 2023 12:41:41 GMT

I have added the year column values explicitly instead of using a MIN & MAX measure to find the first and last year in the year column.

I am not 100% clear how it connects to the original issue to be honest but solved the problem.

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

andhiii079845 — Mon, 27 Feb 2023 13:00:35 GMT

Did you try to add a "calculate" in the var Lastyeardynamic:
Lastyeardynamic = calculate(max(DWH[year])) ?

Re: How to use DAX formula SELECTEDVALUE with Field Parameters

AdamMetz23 — Mon, 27 Feb 2023 14:08:44 GMT

Oh thank you I have added calculate and it made the formula more dynamic. Thank you.