Positive value turns negative after data refresh on Power BI Service

[Anonymous]

Hi,

1 of the KPI card value turns negative when data is refreshed on Power BI service even though the value is positive.When the file is first published on Power BI service the number is correctly displayed as positive value.

Tried using :

-Latest Power BI version

-Clearing browser cache

-Clearing Power BI cache

Request to please assist.Thank you

[Anonymous]

Hi , @Anonymous 

Could you please provide more details about your issue, such as some screenshots or records? Could you please show me your value as well? If it is convenient for you, could you please provide a download link of a sample pbix file containing your issue so we can do further investigation on it? Thanks in advance!

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

Hi Ailsa,

Thank you for the prompt response.I cannot share the PBIX file due to the sensitive information contained within. However, here is a look at the structure of the calculation we are using.

Context – 3 tables (I’ll identify as Table1, Table2, Table3)

Table 1 is linked to Table 2 by Agent_ID

Table 2 is linked to Table 3 by Agent_ID (Table3 is not used in this calculation)

There are several calculations that lead to the final calculation that is currently experiencing issues.

Opening Balance

Taken Hours

Remaining Balance = Opening Balance – Taken Hours

The final calculation is a 90-day rolling calculation of the Remaining Balance, using this formula:

CALCULATE(Table2[Remaining Balance],FILTER(ALL(Table1[Date Field]),Table1[Date Field]> MAX(Table1[Date Field])-90 && Table1[Date Field] <= MAX(Table1[Date Field])))

In Power BI Desktop, the calculation works perfectly. We compared it against raw data, and everything matches. Once we publish it to Power BI Service and refresh the data, the calculation is incorrect, showing a negative value that does not match.

Thank you one again for your assistance