SUM Range divided by Sum Range last 6 rows

[Anonymous]

Hi Guys,

What I would like to get is, each new month to show :

Range of last 6 month (Sale)  / Range of last 6 month (Shop 1 - Categories). 

Anyone could help please ?

Month	Sale	Shop 1 - Categories
Jan	1200	4
Feb	1300	2
Mar	800	5
Apr	500	4
May	600	4
Jun	150	5
Jul	12005

[Anonymous]

OK I managed to get a bit forward with that :

I added ID column 1 2 3 4 ect.

My meaurement =

DIVIDE(SUMx(TOPN(6,'Table','Table'[ID],DESC),'Table'[Sale]),SUMx(TOPN(6,'Table','Table'[ID],DESC),'Table'[Shop 1 - Categories]),0)

So card can show values I want  in connection with column chart ( each time I select another month it all adds up) ,but how to set my results  416,300,253,231,189 on Line chart ? 

Please help ?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Please try measure formulas as below:

Measure1 =
SUMX (
    TOPN (
        6,
        FILTER ( ALL ( 'Table' ), 'Table'[ID] <= MAX ( 'Table'[ID] ) ),
        'Table'[ID], DESC
    ),
    'Table'[Sale]
)

Measure2 =
SUMX (
    TOPN (
        6,
        FILTER ( ALL ( 'Table' ), 'Table'[ID] <= MAX ( 'Table'[ID] ) ),
        'Table'[ID], DESC
    ),
    'Table'[Shop 1 - Categories]
)

Result = [Measure1]/[Measure2]

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.