count number of appearance in a table

[cristianj]

Hello, 

i have this script 

ValidOrdersNumber = calculate(

count(orders[id])

,ALLEXCEPT(orders,orders[buyer_id]),orders[order_state_id]=3) , which count the total number of appearance in table, how can i transform it to tell me the position  of it, i mean it;s the first, the second, the third?...

[id] is primary key

Thank you

[amitchandak · Accepted solution]

@cristianj , Not very clear. One option is have rank on order date

a new column

Rank = ranxk(filter(Table, [buyer_id] =earlier([buyer_id]) ) , [Order date],,asc,dense)

If you are to bucket the occurrence of measure, then you need dynamic segmentation

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[cristianj]

Hello, 

can you help me with one more filter ,  i need also thet order_state_id=3

id	buyer_id	order_stateId
1	asx	1
2	asx	3	1
3	azt	1
4	azt	2
5	azt	3	1
6	asx	1
7	art	1
8	azt	2
9	art	3	1
10	asx	3	2