How to calculate positive values based on existing measure

[Varan_15]

Hi All,

I have table account level balance amount if wherever blank values then i created measure 1 to fetch data from previous day.

now i have measure 1 for the date wise, I have to create another measure to calculate positive values only from existing measure 1.

CALENDAR_DATE	holiday	ACCOUNT_NO	Balance	Measure 1
01/04/2024 0:00	weekday	11016	6988.625	6988.625
02/04/2024 0:00	weekday	11016		6988.625
03/04/2024 0:00	weekday	11016	200	200
04/04/2024 0:00	weekday	11016	-63620.463	-63620.463
05/04/2024 0:00	Weekend	11016		-63620.463
06/04/2024 0:00	Weekend	11016		-63620.463
07/04/2024 0:00	weekday	11016	-31.359	-31.359
08/04/2024 0:00	weekday	11016	-31.359	-31.359
09/04/2024 0:00	Holiday	11016		-31.359
10/04/2024 0:00	Holiday	11016		-31.359
11/04/2024 0:00	Holiday	11016	168.641	168.641
12/04/2024 0:00	Weekend	11016		168.641
13/04/2024 0:00	Weekend	11016		168.641
14/04/2024 0:00	weekday	11016	-31.359	-31.359
15/04/2024 0:00	weekday	11016	168.641	168.641
16/04/2024 0:00	weekday	11016	168.641	168.641
17/04/2024 0:00	weekday	11016	168.641	168.641
18/04/2024 0:00	weekday	11016	-31.359	-31.359
19/04/2024 0:00	Weekend	11016		-31.359
20/04/2024 0:00	Weekend	11016		-31.359
21/04/2024 0:00	weekday	11016	168.641	168.641
22/04/2024 0:00	weekday	11016	168.641	168.641
23/04/2024 0:00	weekday	11016	-31.359	-31.359
24/04/2024 0:00	weekday	11016	978.685	978.685
25/04/2024 0:00	weekday	11016	168.569	168.569
26/04/2024 0:00	Weekend	11016		168.569
27/04/2024 0:00	Weekend	11016		168.569
28/04/2024 0:00	weekday	11016	168.569	168.569
29/04/2024 0:00	weekday	11016	-10915.165	-10915.165
30/04/2024 0:00	weekday	11016	166.78	166.78

expected result:

for this customer (11016) -> April month total value will be : 17346.119

kindly help me to create measure.

Thanks in advance

[Tahreem24]

@Varan_15  Try this measure:

Measure = CALCULATE([Measure1],FILTER('Table',[Measure1]>0))

[Varan_15]

@Tahreem24 ,

Thanks for the update,

I have used the same measure logic but total is wrong. PFB

CALENDAR_DATE	ACCOUNT_NO	Holiday	sum of balance	Measure 1	Final Measure
01/04/2024 0:00	11016	weekday	6988.625	6988.625	6988.625
02/04/2024 0:00	11016	weekday		6988.625
03/04/2024 0:00	11016	weekday	200	200	200
04/04/2024 0:00	11016	weekday	-63620.463	-63620.463
05/04/2024 0:00	11016	Weekend		-63620.463
06/04/2024 0:00	11016	Weekend		-63620.463
07/04/2024 0:00	11016	weekday	-31.359	-31.359
08/04/2024 0:00	11016	weekday	-31.359	-31.359
09/04/2024 0:00	11016	Holiday		-31.359
10/04/2024 0:00	11016	Holiday		-31.359
11/04/2024 0:00	11016	Holiday	168.641	168.641	168.641
12/04/2024 0:00	11016	Weekend		168.641
13/04/2024 0:00	11016	Weekend		168.641
14/04/2024 0:00	11016	weekday	-31.359	-31.359
15/04/2024 0:00	11016	weekday	168.641	168.641	168.641
16/04/2024 0:00	11016	weekday	168.641	168.641	168.641
17/04/2024 0:00	11016	weekday	168.641	168.641	168.641
18/04/2024 0:00	11016	weekday	-31.359	-31.359
19/04/2024 0:00	11016	Weekend		-31.359
20/04/2024 0:00	11016	Weekend		-31.359
21/04/2024 0:00	11016	weekday	168.641	168.641	168.641
22/04/2024 0:00	11016	weekday	168.641	168.641	168.641
23/04/2024 0:00	11016	weekday	-31.359	-31.359
24/04/2024 0:00	11016	weekday	978.685	978.685	978.685
25/04/2024 0:00	11016	weekday	168.569	168.569	168.569
26/04/2024 0:00	11016	Weekend		168.569
27/04/2024 0:00	11016	Weekend		168.569
28/04/2024 0:00	11016	weekday	168.569	168.569	168.569
29/04/2024 0:00	11016	weekday	-10915.165	-10915.165
30/04/2024 0:00	11016	weekday	166.78	166.78	166.78
Total			-65009.349	-184712.666	9683.074

[Anonymous · Accepted solution]

Hi @Varan_15 

Thanks for the reply from @Tahreem24  .

@Varan_15 , please try the following measure.

Measure = SUMX(FILTER('Table', [Measure1] > 0), [Measure1])

Output:

Because I don't know what the calculation logic of your measure1 is, the measure1 I wrote is just to restore your scenario.

Best Regards,
Yulia Xu

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