Forum Discussion
AdamMetz23
Advocate I
Advocate IHow to use DAX formula SELECTEDVALUE with Field Parameters
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...
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?Did you try to add a "calculate" in the var Lastyeardynamic:
Lastyeardynamic = calculate(max(DWH[year])) ?
andhiii079845
Solution Sage
Solution SageOne question: Why it is important to use field parameters instead of a regular table / calculated table?
AdamMetz23Advocate I
Advocate IThank 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