costumer by last N order id's

[Sebas2404]

For a sales visualisation I would like te calculate the sales for each costumer based on the last 5 sales.

Normally would could use the N last days from today. However I'm not intrested to use date but rather the last n orderID's.

Visual the calculation looks like this:

I used:

TOPN_SU2 = TOPN(5, DimSU_Number, DimSU_Number[SU Number], DESC)

But this only delivers the last orderID's and is not filtered on costumer.

 

[amitchandak]

@Sebas2404 , Create a column like this in order table

orderID Rank = rankx(filter('Table', [Customer] = earlier([customer])), [orderID],,asc,dense)

then try one of the two measures

Measure = CALCULATE(COUNT('Table'[Amount]) ,FILTER(('Table'),'Table'[orderID Rank] >=CALCULATE(max('Table'[orderID Rank])-5,ALLEXCEPT('Table','Table'[process]))))

or
Measure =
VAR __id = MAX ('Table'[Customer] )
VAR __rank = CALCULATE ( MAX('Table'[orderID Rank] ), ALLSELECTED ('Table' ), 'Table'[Customer] = __id )
CALCULATE ( sum ('Table'[Amount] ), VALUES ('Table'[Customer ),'Table'[Customer] = __id,'Table'[orderID Rank] = __rank )

My Latest Blog: https://community.powerbi.com/t5/Community-Blog/Important-Links-every-Power-BI-enthusiastic-should-b...

[Sebas2404]

@amitchandak I Tried the formule orderID Rank = rankx(filter('Table', [Customer] = earlier([customer])), [orderID],,asc,dense) with new colom en that works fine. 

THANKS FOR THE FIRST STEP!

With the first measure ->  Measure = CALCULATE(COUNT('Table'[Amount]) ,FILTER(('Table'),'Table'[orderID Rank] >=CALCULATE(max('Table'[orderID Rank])-5,ALLEXCEPT('Table','Table'[process]))))

What do you mean with ALLEXCEPT('Table','Table'[process])))) ?

the process is new for me

[Sebas2404]

@amitchandak some addition infortmation regarding the end result:

for each value of SU number I want to sum its own number with the last n SU number and there value for ech Su number in my filter range. 

Hopes this clarifies the question.

Thanks in advance