Error in dynamic format

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.