Hi @mohamed.ruzli.moham ,

When editing the KPI in the top you have formatting options (should show 'unformatted' or similar currently). Setting this to 'percentage' will add a percentage sign.

Please let me know if this helped! (and mark my post as an answer if it did :D)

Thanks :)

Hi, Mohamed,

Are you sure is PU_COUNT, and not PU_SUM? PU_COUNT returns the number of entries for each fruit, while PU_SUM returns the sum of the quantities (which I believe is what you're looking for...).

KPI = PU_SUM(...)/GLOBAL(SUM("Your_Table"."Your_Column"))

This will give you the percentage of each fruit in the total.

Hope this helps! ;)