How to find partners cummulative sales

[vs_7]

hi,

please help to find the partner cummulative sales from total sales.

please check below data in table format.

Date	C Month Num	C Year	F Year	Quarter	Display Year	Month Name	PARTNERCODE	NETVALUE	Unit	Unit Values	Sort
01-05-2019	5	2019	2019	Q1	2019-2020	January	MY05I23485	47042.44	CR	10000000	3
02-05-2019	5	2019	2019	Q1	2019-2020	January	MR05I21910	51750.32	Lac	100000	2
03-05-2019	5	2019	2019	Q1	2019-2020	January	MR05I21910	28525.18	K	1000	1
04-05-2019	5	2019	2019	Q1	2019-2020	January	30APP04100	21070.3
05-05-2019	5	2019	2019	Q1	2019-2020	January	30APP04100	30000
06-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	900
07-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	62819.11
08-05-2019	5	2019	2019	Q1	2019-2020	January	FI05A19162	50391.09
09-05-2019	5	2019	2019	Q1	2019-2020	January	30ANA04100	88000
10-05-2019	5	2019	2019	Q1	2019-2020	January	RETAIL4100	2098.36
01-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	20800
02-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	22500
03-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	6250
04-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	557839.98
05-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	89640
06-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	1430047.94
07-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	480791.98
08-07-2019	7	2019	2019	Q2	2019-2020	January	30APP04100	88375
09-07-2019	7	2019	2019	Q2	2019-2020	January	30LED04100	156000
10-07-2019	7	2019	2019	Q2	2019-2020	January	SYS05I6711	1671597.54
01-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	815413.44
02-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	2832489.18
03-10-2019	10	2019	2019	Q3	2019-2020	January	SYS05I6711	38610
04-10-2019	10	2019	2019	Q3	2019-2020	January	DA05I23887	930600
05-10-2019	10	2019	2019	Q3	2019-2020	January	FI05A19162	55276.2
06-10-2019	10	2019	2019	Q3	2019-2020	January	30SYS04100	80000
07-10-2019	10	2019	2019	Q3	2019-2020	January	30SYS04100	2450000
08-10-2019	10	2019	2019	Q3	2019-2020	January	30INT04100	8840000
09-10-2019	10	2019	2019	Q3	2019-2020	January	30INT04100	320000
10-10-2019	10	2019	2019	Q3	2019-2020	January	EG02I27433	4696530.55

[vs_7]

HI @v-angzheng-msft,

I have tried above measure but im getting error and i have used total Revenue measure for Netvalue.

i'm having date in Master calender table 

please check screenshot below.

Measure =

CALCULATE(SUM('sales'[Total Revenue]),FILTER(ALL('Sales'),'Sales'[PARTNERCODE]=MAX('Sales'[PARTNERCODE])&&'Master_calender'[Date]<=MAX('Master_Calendar'[Date])))

[v-angzheng-msft]

Hi, @vs_7 
Please try to sum the column directly, not to the measure.Or remove the summation.

Measure =
CALCULATE (
    SUM ( 'sales'[TheColumn_NotMeasure] ),
    FILTER (
        ALL ( 'Sales' ),
        'Sales'[PARTNERCODE] = MAX ( 'Sales'[PARTNERCODE] )
            && 'Master_calender'[Date] <= MAX ( 'Master_Calendar'[Date] )
    )
)

Or

Measure =
CALCULATE (
    'sales'[TheMeasure],
    FILTER (
        ALL ( 'Sales' ),
        'Sales'[PARTNERCODE] = MAX ( 'Sales'[PARTNERCODE] )
            && 'Master_calender'[Date] <= MAX ( 'Master_Calendar'[Date] )
    )
)

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft · Accepted solution]

Hi, @vs_7 

Try this:

Measure = 
CALCULATE(SUM('Table'[NETVALUE]),FILTER(ALL('Table'),'Table'[PARTNERCODE]=MAX('Table'[PARTNERCODE])&&'Table'[Date]<=MAX('Table'[Date])))

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.