How to create measure with dynamic aggregation and format ?

Question

Hi,&nbsp;Supposed that i have a database with fews variable like :&nbsp;variable&nbsp;value&nbsp;Total Profit100,687Investments Profit19,747Gross Loss Ratio32%Net Loss Ratio54%&nbsp;&nbsp;The variable will be in the filter section and i would like to show depending on the selection the right format on a clustered bar.In a simple table, it work but not on the graph because of the X axis who stay between 0 and 1.&nbsp;_values4 = SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; true(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Total Profit" in ALLSELECTED('Global'[variable]), [sum_value] , &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Investments Profit" in ALLSELECTED('Global'[variable]), [sum_value] , &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Gross Loss Ratio" in ALLSELECTED('Global'[variable]), [avg_value]&nbsp;)&nbsp;with theSum_value = sum('Global'[value]) and&nbsp;Avg_value = &nbsp;average('Global'[value])&nbsp;I tried to change the Avg_value with format function or contatenate but its not workingAvg_value = CONCATENATE( average('Global'[value])*100 , "%")&nbsp;If someone can help 🙂&nbsp;thank you&nbsp;&nbsp;

amitchandak · Answer

menphis21 , if you are using this code in a measure slicer, My advice would be to check if the field parameter can be used
https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

menphis21 · Answer

Thank you, i dont have the option to create new parameter with fields.I tried to write the same the code also but its not working. There is another solution ?&nbsp;Thanks

anonymous · Answer

Hi&nbsp;menphis21&nbsp;,
What's the version of your Power BI Desktop? You can upgrade to the latest one if it still not be the&nbsp;latest version. Please check if you can find the option "Field parameters"&nbsp; in Options page...

Besides that, there are some limitations on using Field parameters, and these can also cause the field parameter to not work properly...

In addition, you can refer the following links to dynamic
Creating Value Dynamic Formatting using Calculation Groups
Dynamic Formatting of Switch Measures in Power BI

Best Regards

anonymous · Answer

Hi&nbsp;&nbsp;menphis21&nbsp;,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards

menphis21 · Answer

Hi&nbsp;Anonymous&nbsp;,I am still trying to resolve it and the filed paramter didnt permit me to revole it or i dont know how to.In one field, i have few variable, how can configure that ?&nbsp;variable&nbsp;value&nbsp;Total Profit100,687Investments Profit19,747Gross Loss Ratio32%Net Loss Ratio54%&nbsp;

Forum Discussion

How to create measure with dynamic aggregation and format ?

5 Replies

Related content

Dynamic measure filtering

Dynamic Measure developement

Slicers on Aggregated Measures

Dynamic Measure with Fieldparameters

Data Aggregation issue

variable	value
Total Profit	100,687
Investments Profit	19,747
Gross Loss Ratio	32%
Net Loss Ratio	54%

variable	value
Total Profit	100,687
Investments Profit	19,747
Gross Loss Ratio	32%
Net Loss Ratio	54%