Forum Discussion
Super UserHow to create % of All using field parameters?
Super UserHi Community Support Team _ Eason
Thank you for the reply.
But there seems to have been a bit of misunderstanding.
I specifiaclly want to know if/how Field Parameteres can be included in measures.
Field Parameteres are a new preview feature in the May 2022.
Have you tried using Field Parameteres yet?
I already knew how to use ALL to calculate % for individual measures,
but I am curious if we can include Field Parameteres in any measures.
I just gave % as an example, but the question is about Field Parameteres in measures and not % per se.
Has anyone tried to build an advance reports with Field Parameteres inside measures yet?
Thank you
Community SupportHi, speedramps
I'm afraid field Parameteres can‘t used for calculations. If you examine the generated code, you will see that it is essentially a parameter table that contains some values of type 'String'. Function ’SUM‘ cannot work with these string fields.
In my opinion, the field parameter is used to call the result of measure and the final result is still calculated in the corresponding measure.
Best Regards,
Community Support Team _ Eason
- speedramps
Thank you v-easonf-msft
Yeap, I am aware that Field Parameter creates Calculated Table in the background.
The run query then creates the "code" which you can grab using Performance Analyser and paste it into Dax studio.
Field Parameters are a new preview feature in the May 2022 release, and I hopeful someone will fathom how to use them dynamical in measures. Alberto has published a good video about it.
Perhaps “ALL” was a bad example and has side tracked my issue.
I might close this ticket in a few days it we dont get back on track, and raise another ticket with more emphasis on “Field Parameter in Measures”. It would be a good feataure to have.