how to count a measure with string values

[learningOh]

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 solution]

Hi @learningOh ,

I made a simple example for reference. 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.

You can also download my attachment for more details.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Ritaf1983]

Hi @learningOh 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523