Help me create Calculated Column

[FrankWoody]

I have a column containing items like A,B,C,D.
I would like to create a calculated column evaluating the following question: If the row of this column is equal to "A" then return 100%, If the row of this column is equal to "B" then return 85% ,
the row of this column is equal to "C" then return 65%, the row of this column is equal to "D" then return 50%. is it possible to do that ?

[FrankWoody]

THANKS So much !
Now is there any way for me to assign these values to specific texts, if I have a character set and want to filter a part of the text of the line does it also work?

[SpartaBI]

@FrankWoody my pleasure. 
Sure you can, check out this function:
https://dax.guide/containsstring/
You can also explore there related functions.
Don't forget to mark my previous respond as a solution for comunity visabilty.

P.S. check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

[SpartaBI · Accepted solution]

@FrankWoody 

Column = 
SWITCH(
	'Table'[Item Column],
	"A", 1,
	"B", 0.85,
	"C", 0.65,
	"D", 0.5
)

And then, format this column as percentage

Showcase Report – Contoso By SpartaBI