Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Count
Count( {<[Column A]={ 'ABC'} >}[Column A])
Ratio
Count( {<[Column A]={ 'ABC'} >}[Column A]) / Count( {<[Column A]={ 'XYZ'}>}[Column A])
Count
Count( {<[Column A]={ 'ABC'} >}[Column A])
Ratio
Count( {<[Column A]={ 'ABC'} >}[Column A]) / Count( {<[Column A]={ 'XYZ'}>}[Column A])