Forum Discussion
Measure to Count by Last Stage
I am trying to write a pair of measures but I'm stuck. I'm working with a table that gives the history of clients through a series of processing stages. Each row represents a stage movement event, gi...
Greg_Deckler
Community Champion
Community ChampionHighestStage = MAXX(FILTER(stages,[Client]=[Client]),[Stage])
Create as a Measure.
Create another measure:
MyCount1 = COUNTX(FILTER(stages,[Stage]=[Highest]),[Stage])
Put Stage and this measure in a column chart. Make sure [Stage] is set to "Do not summarize".
Anonymous
Sorry, hit post before I was ready!!
Hmm. That just returns the max stage value for each row. And the rows are themselves stage values. So I get:
Stage HighestStage 1 1 2 2 3 3 4 4 5 5 6 6 7 7
What I'm looking for is for HighestStage to give me a count of clients per stage, but only count the clients on the stage row where that was the highest stage they reached. So a client who made it to stage 5 would not be counted on rows 1-4, but only on 5, etc.