Pronlem with Cache

[Maks_Zarin]

Hello.
I have a problem with displaying data for live connection to analisys analysis services database. When I put a filter by categories, total sum is calculated without it:

I think that the total sum is taken from the cache, which has a bug. The cache-clearing feature in powerBI does not help.

without filter

with filter

[v-haibl-msft]

@Maks_Zarin

This should be as designed since Power BI has a client query result cache to reduce the amount of query data request to server. If the query generated by user interaction was cached, then user will see the cached data unless they click the refresh button.

You can also try to set the maximum cash size to be smaller in Options – Data Load to see if it helps. And There is a related idea here.

Best Regards,

Herbert

[Maks_Zarin]

Refresh and decreasing the cache to 0 does not help. 
Is the problem in something else?

[v-haibl-msft]

@Maks_Zarin

For the total sum, is it a defined measure? If yes, could you please check the formula of it to see if it ignores the category.

Best Regards,

Herbert

[Maks_Zarin]

Hello.
Total sum is not a defined measure, it is standart feature for visual element 'table'.
'Выручка' is defined measure in olap-cube, but in excel shows right value.