Report Page view in user matrix report model not match with old user matrix report

Anonymous — Thu, 28 Sep 2023 03:51:16 GMT

Hi Experts,

I've use user matrix report model (below) to create a report showing all report usage (Microsoft default it's latest 30 days).

However, I found the page view was not align with old user matrix report (below), especially the views on "starting" date (like my report launch at 28 Aug 2023 with >300 views in old matrics report ( I check by extract data in excel), when I saw report on 28 Sep 2023, views on 28 Aug 2023 shows only 2 views .... which led to drastically drop in Total view).

I've search on web and understand data retrive source was different between old (from client side) and new (from Audit log) version of user matrix report.

Kindly ask :

which field in (new) user matrix model use to count report page view in old report (below) ? I've try all Microsift build-in
measure, include page view, total page views, report views but all didn't show correctly (and they block user to view the DAX so don't know backend calculating logic ....).
The chart I'm show was cumulative running total views with below DAX. Views on 28 Aug 2023 was 331 (from old report) but only shows 2 in model

I have other report as well so manual donwload old report data as model source is not a good solution.

Thanks.

topic Report Page view in user matrix report model not match with old user matrix report in DAX Commands and Tips

Report Page view in user matrix report model not match with old user matrix report