How to create measure with dynamic aggregation and format ?

[menphis21]

Hi,

Supposed that i have a database with fews variable like : 

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

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.

_values4 = SWITCH(

                true(),

                  "Total Profit" in ALLSELECTED('Global'[variable]), [sum_value] ,

                  "Investments Profit" in ALLSELECTED('Global'[variable]), [sum_value] ,

                    "Gross Loss Ratio" in ALLSELECTED('Global'[variable]), [avg_value] )

with the

Sum_value = sum('Global'[value]) and 

Avg_value =  average('Global'[value])

I tried to change the Avg_value with format function or contatenate but its not working

Avg_value = CONCATENATE( average('Global'[value])*100 , "%")

If someone can help 🙂

thank you

[menphis21]

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 ?

Thanks

[Anonymous]

Hi  @menphis21 ,

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]

Hi @Anonymous ,

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 ?

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

[Anonymous]

Hi @menphis21 ,

What's the version of your Power BI Desktop? You can upgrade to the latest one if it still not be the latest version. Please check if you can find the option "Field parameters"  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

[amitchandak]

@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-fc4095ae9af...