Count occurrence of a row condition at any given point

[BiNewBi]

I am basically trying to get data seen below in RANK  column. (sample from the same forum on a follwo up question here )

[v-juanli-msft]

Hi @BiNewBi

in editor queries

Add Column->Extract, "last character"

"Apply & Close", then go to Report View

Create measures below

project number = SUM(Table1[Last Characters])

Measure = RANKX(FILTER(ALL(Table1),[Points]=SELECTEDVALUE(Table1[Points])),[project number],,ASC)

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @BiNewBi

in editor queries

Add Column->Extract, "last character"

"Apply & Close", then go to Report View

Create measures below

project number = SUM(Table1[Last Characters])

Measure = RANKX(FILTER(ALL(Table1),[Points]=SELECTEDVALUE(Table1[Points])),[project number],,ASC)

Best Regards

Maggie