Unable to change datatype of measure

[Anonymous]

Hi,

I want to show a measure that I created as %. But the datatype is locked as decimal and I can't change it to whole number. Any ideas?

This is the number I want, but with a % behind:

But when I select % in the modeling ribbon, I get this:

I think changing it to whoule number would fix it, but is locked. The columns I calculate is both whole number.

The calculation I'm doing is this:

That should be 26/154*100 which is 17 if you use round()

[amitchandak · Accepted solution]

If you want to mark as percent column. Then no need to multiply by 100. Multiply with 1.0 to make it decimal

[Anonymous]

@amitchandak  ah, haha maybe I should have thought about that.

Thanks  for pointing that out.