Forum Discussion
109264
3 years agoFrequent Visitor
Custom Usage Report in PBI Desktop
Can anyone tell me how to get a matrix that contans the number of the Report Views by Section ID. I'm trying to create a hirarchy of the Report Name and Section Name in a report, but there seems to b...
Sahir_Maharaj
Super User
3 years agoOnce you have this table, you can create a measure that calculates the number of report views for each Section ID. You can do this by using the COUNT or SUM aggregation function on a field that contains the number of views for each report.
Sahir_Maharaj
Super User
3 years agoYou can also add a drill-through hierarchy to your matrix visual to allow you to navigate the report structure and view the details of each report view by Section ID. To do this, you can create a hierarchy using the Report Name and Section Name fields and then enable the drill-through option in the matrix visual.