Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Refresh and decreasing the cache to 0 does not help.
Is the problem in something else?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |