how to count a measure with string values

Question

Hi everyone,i am trying to count the number of occurrences of the string values, "win", "loss", "retained", "NA".i have a measure that tags a label to each customercode. i use a measure instead of a column because there is a slicer that the user can use to determine a period of inactivity for the customercode. for example, if the slicer chosen is 6 months, that means that if the customer has no revenue in 6 months, they are lost. if the revenue is the same as the total revenue, means the customer is new etc.i want to count the number of occurences in the measure below. so that i know how many customers are won, loss etc. how do i do so?

anonymous · Accepted Answer

Hi&nbsp;learningOh&nbsp;,
&nbsp;
I made a simple example for reference.&nbsp;There is a code column, the test measure, just like in your screenshot. Then you want to calculate the number of wins and losses.

Create a table for different types. Here I used Enter Data.

Create a measure for counting.
Count = COUNTX(FILTER('Table',[test]=MAX('Table (2)'[type])),[Code])
Then check the below table visual.

&nbsp;
You can also download my attachment for more details.
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

how to count a measure with string values

2 Replies

Related content

Measure for string values?

Measure returning incorrect value

Measuring similarity between strings

Blank columns when doing Measure Name Measure Value approach

Create a Measure based on string value