Issue with incremental value calculation

Question

Hi,I appied the below and the respose which iam getting is wrong.&nbsp;Daily Reported = VAR mydate = MAX(Recovered[Date]) return SUM(Recovered[Value])-CALCULATE(SUM(Recovered[Value]),FILTER(ALLSELECTED(Recovered),Recovered[Date]=mydate-1))&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

ajithtravvise · Answer

Hi Greg,&nbsp; &nbsp; Thank for the suggestion, I tried my best to work this out with out sucess...&nbsp;Ajith

ajithtravvise · Answer

Any one can help me with the below please&nbsp;dax&nbsp;Greg_Deckler&nbsp;

greg_deckler · Answer

Paste the sample data as text please.&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

ajithtravvise · Answer

,Recovered,US,2020-04-07 23:04:49,,,0,0,21763,0,"Recovered, US"
,,Reunion,France,2020-04-07 23:04:29,-21.1151,55.5364,358,0,40,318,"Reunion, France"
,,Saint Barthelemy,France,2020-04-07 23:04:29,17.9,-62.8333,6,0,1,5,"Saint Barthelemy, France"
,,Saint Pierre and Miquelon,France,2020-04-07 23:04:29,46.8852,-56.3159,1,0,0,1,"Saint Pierre and Miquelon, France"
,,Saskatchewan,Canada,2020-04-07 23:11:15,52.9399,-106.4509,260,3,0,0,"Saskatchewan, Canada"
,,Shaanxi,China,2020-04-06 01:14:34,35.1917,108.8701,256,3,246,7,"Shaanxi, China"
,,Shandong,China,2020-04-07 00:55:26,36.3427,118.1498,781,7,755,19,"Shandong, China"
,,Shanghai,China,2020-04-07 06:21:55,31.201999999999998,121.4491,538,6,406,126,"Shanghai, China"
,,Shanxi,China,2020-04-05 00:58:54,37.5777,112.2922,138,0,133,5,"Shanxi, China"
,,Sichuan,China,2020-04-07 01:35:16,30.6171,102.7103,560,3,541,16,"Sichuan, China"
,,Sint Maarten,Netherlands,2020-04-07 23:04:29,18.0425,-63.0548,40,6,1,33,"Sint Maarten, Netherlands"
,,South Australia,Australia,2020-04-07 23:11:31,-34.9285,138.6007,411,1,53,357,"South Australia, Australia"
,,St Martin,France,2020-04-07 23:04:29,18.0708,-63.0501,32,2,7,23,"St Martin, France"
,,Tasmania,Australia,2020-04-07 23:11:31,-42.8821,147.3272,89,2,26,61,"Tasmania, Australia"
,,Tianjin,China,2020-04-07 00:20:57,39.3054,117.323,180,3,151,26,"Tianjin, China"
,,Tibet,China,2020-02-23 11:19:02,31.6927,88.0924,1,0,1,0,"Tibet, China"
,,Turks and Caicos Islands,United Kingdom,2020-04-07 23:04:29,21.69400000000001,-71.7979,8,1,0,7,"Turks and Caicos Islands, United Kingdom"
,,Victoria,Australia,2020-04-07 23:11:31,-37.8136,144.9631,1191,11,620,560,"Victoria, Australia"
00078,,Virgin Islands,US,2020-04-07 23:04:49,18.3358,-64.8963,43,1,0,0,",Virgin Islands,US"
,,Western Australia,Australia,2020-04-07 23:11:31,-31.9505,115.8605,460,4,162,294,"Western Australia, Australia"
,,Xinjiang,China,2020-03-08 05:31:02,41.1129,85.2401,76,3,73,0,"Xinjiang, China"
,,Yukon,Canada,2020-04-07 23:11:15,64.2823,-135.0,7,0,0,0,",Yukon,Canada"
,,Yunnan,China,2020-04-07 00:20:57,24.974,101.48700000000001,184,2,173,9,"Yunnan, China"
,,Zhejiang,China,2020-04-07 02:06:38,29.1832,120.0934,1265,1,1230,34,"Zhejiang, China"
,,,Afghanistan,2020-04-07 23:04:29,33.93911,67.709953,423,14,18,391,Afghanistan
,,,Albania,2020-04-07 23:04:29,41.1533,20.1683,383,22,131,230,Albania
,,,Algeria,2020-04-07 23:04:29,28.0339,1.6596,1468,193,113,1162,Algeria
,,,Andorra,2020-04-07 23:04:29,42.5063,1.5218,545,22,39,484,Andorra
,,,Angola,2020-04-07 23:04:29,-11.2027,17.8739,17,2,2,13,Angola

Forum Discussion

Issue with incremental value calculation

6 Replies

Related content

Incremental Refresh Issue

Incremental Refresh - issue

Increment Refresh

Incremental Refresh Timeout Issue with Large Dataset

Matrix calculation Issue - DAX