How to use DAX formula SELECTEDVALUE with Field Parameters

[AdamMetz23]

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

[andhiii079845 · Accepted solution]

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? 

[andhiii079845]

What was the solution now in your case ? 🙂

[AdamMetz23]

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.

[andhiii079845 · Accepted solution]

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

[AdamMetz23]

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

[andhiii079845 · Accepted solution]

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? 

[andhiii079845]

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

[AdamMetz23]

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