Incremental refresh set up

[Anonymous]

Hi, I am trying to set up an incremental refresh like this 

On my report, there is a measure like this

Total Qty = SUM(Table[Quantity])

After publish this report to BI service, the measure's value has double up somehow (e.g  "1" in BI desktop, "2" in BI service)

May I know if anyone come accross with this case and how I could solve?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure, but sometimes in my cases, in Power Query Editor, when setting up the filter by parameters, one has to be greater than, and the other has to be less than or equal to (or other way round).

It cannot be greater than or equal to and less than or equal to (equal cannot be on both side).

I hope this helps.

Thank you.

[Anonymous]

@Jihwan_Kim your solution has prefectly solved the issue.