Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Particular cell to Percentage format

Hi All,   Need you help to change a perticular cell to % if the correspondent row is specific text.   This is how i have the data. Expected output is as below     Whereever column...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , That will make you measure as text type meausre

Create a score measure

score m=  sum(Table[Score])

 

 

then try like

if(Max(Table[Type]) = "Approval"), format([score m],"percent"), , format([score m],"number") )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amit,

     

    Thanks for sharing, but it is not working