Categorical Field count

[rish]

Suppose I have following data in an excel:

Column A

ABC

ABC

XYZ

and I want to display the ratio of occurences of ABC to XYZ(2:1) along with no. of occurences or "Count" of ABC(2), how do i write an expression for it?

[Vegar · Accepted solution]

Count

Count( {<[Column A]={ 'ABC'} >}[Column A])

Ratio

Count( {<[Column A]={ 'ABC'} >}[Column A]) / Count( {<[Column A]={ 'XYZ'}>}[Column A])

[rish]

Thanks vegar. It worked

[Vegar]

Glad to be of help ☺️

— Vegar