Forum Discussion
Properly Referencing Field Parameters in a Measure
PineTree , Not very clear, but you can use [Parameter-WE Date_Order] to get selected value. refer
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw
Hello amitchandak , thank you for your response.
I made some minor edits to help with clarity.
To use the example you cited here to demonstrate my issue, lets first pretend 'Item'[Brand] and 'Item'[Category] are numeric values (maybe cost and revenue?). Now lets find the maximum value in 'Item'[Brand]/'Item'[Category] based on the Parameter selected by the user by creating a measure...
New Measure = Max('Parameter'[Parameter Fields])
This won't work because the value of 'Parameter'[Parameter Fields] is being treated as text and not as a column reference.
Do you know how to make [New Measure] work?
Does this provide enough clarity?
Thank you for your time amitchandak