Error in dynamic format

Ferha_Jafri — Sat, 14 Sep 2024 16:31:45 GMT

Hello Experst,

I am getting below error while using dynamic formatting as

var selected_toggle = SELECTEDVALUE(View[Value])

var var_value = SWITCH(TRUE(),

selected_toggle = "Total Premium","$#,0" ,

selected_toggle = "Total Incurred", "$#,0" ,

selected_toggle = "No. of Claims", "#,0"

)

RETURN var_value

Dax expression is

Prem_Cla_Inc toggle =

var selected_toggle = SELECTEDVALUE(View[Value])

var var_value = SWITCH(TRUE(),

selected_toggle = "Total Premium",[Sum_Premium],

selected_toggle = "Total Incurred",[Sum_Incured],

selected_toggle = "No. of Claims",[# Claims],0

)

RETURN var_value

return type for this is a number.

Error :

Can someone help me as what I am doing wrong here.

Re: Error in dynamic format

Anonymous — Mon, 16 Sep 2024 06:47:32 GMT

Hi, @Ferha_Jafri

I’ve provided two solutions for you:

1.Firstly, modify the format as follows:

var selected_toggle1 = SELECTEDVALUE(View[Value]) var var_value1 = SWITCH(TRUE(), selected_toggle1 = "Total Premium","$#,0" , selected_toggle1 = "Total Incurred", "$#,0" , selected_toggle1 = "No. of Claims", "#,0" ,"0" ) RETURN var_value1

The error occurred previously because you returned 0 instead of “0”. The output might be a number rather than a string.

2.Secondly, directly modify the measure to the following measure:

Measure = var selected_toggle = SELECTEDVALUE(View[Value]) var var_value = SWITCH(TRUE(), selected_toggle = "Total Premium",FORMAT([Sum_Premium],"$#,0"), selected_toggle = "Total Incurred",FORMAT([Sum_Incured],"$#,0"), selected_toggle = "No. of Claims",FORMAT([# Claims],"#,0"),0 ) RETURN var_value

This way, the format will be corrected directly when the measure outputs.

3.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Error in dynamic format in Developer

Error in dynamic format

Re: Error in dynamic format