Measure to count text in column

[gonrodrigues]

Hello

How can i create a measure to count two different values in a column at the same time? 

P.E. a column with 'a', 'b', 'c'. I want to count 'a' and 'c'.

Thanks!

[ankitpatira · Accepted solution]

@gonrodrigues Create two measure with below code.

CountValuesA =
CALCULATE ( COUNTROWS (YourTable); YourTable[YourColumn] = "a" )

CountValuesC =
CALCULATE ( COUNTROWS (YourTable); YourTable[YourColumn] = "c" )

[Calumc12]

@ankitpatira 

I seem to be having a syntax issue with the second part i.e.

YourTable[YourColumn] = "a" )

 Do i need a formula here to read the data in my data

[gonrodrigues]

If I'm creating a measure that is a percentage, how can i put '%' symbol in the end to present that in a card?

Thanks @ankitpatira

[sdjensen]

On the "Modeling" tab you can format the measure as a percentage.

[gonrodrigues]

Thanks a lot! @sdjensen