topic Re: Inconsistent Measure Calculation Across Users in Management & Governance

Inconsistent Measure Calculation Across Users

jm4 — Wed, 01 Mar 2023 16:04:36 GMT

I manage a tenant. When recently reviewing a table with another user, we discovered that we were seeing different results for one of the table's measures. In the attached images, I've highlighted the file number on the left and the measures in question on the right. We were looking at the same data point and we were using the same filters. How would you recommend I troubleshoot an issue like this?

Re: Inconsistent Measure Calculation Across Users

Frank_S — Wed, 01 Mar 2023 23:52:46 GMT

Hi @jm4

How exactly are you filtering?

Is section access in use at all?

Is there a calculated column that might be causing the issue?

Check the above first.

If none of the above apply and if you can reproduce the issue consistently with other apps then it 'could' be a bug.

But I suspect it could have to do with the design of the chart and how the table columns are constructed (if calculated for example).

Also, try to clear cookies and the browser cache to ensure they aren't seeing cached data...not likely but something to check. (you an incognito window if you don't want to clear cookies and cache).

Kind regards...

Re: Inconsistent Measure Calculation Across Users

marcus_sommer — Thu, 02 Mar 2023 11:30:45 GMT

A bug seems for me quite unlikely because the incorrect called values seems to be just twice as much. This hints for differences within the data-set and other user-depending measures, for example any variables or master-items (user-depending calculated and/or stored in bookmarks).

Re: Inconsistent Measure Calculation Across Users

jm4 — Thu, 02 Mar 2023 21:24:50 GMT

I recreated the table in another app and the inconsistent calculation went away. It must have been caused by the complex data structure of the original app. Thanks for the advice!

Re: Inconsistent Measure Calculation Across Users

Frank_S — Thu, 02 Mar 2023 22:28:50 GMT

No worries @jm4

Glad I could help point you in the right direction.

Kind regards...