Dynamic Formatting issue

[akerrout]

Hello All,
I have been working with dynamic formatting ( see the screen below )

I am filtering specific account of my account list in order to return different formating. 
The account in % it returns "0.00" which is what i want
but for the other account I want to show in K. "#,##0,K".

The issue is that the numbers are not in thousand,  the first line should be 115' 064 '753.


Thank you for your help

[v-binbinyu-msft · Accepted solution]

Hi @akerrout ,

Please try below dax formula:

var cur_ac=SELECTEDVALUE('Table'[Account])
return
IF(CONTAINSSTRING(cur_ac,"%"),"0.00","#,##0,")

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.