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
3 years agoSuper User
Once 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
3 years agoSuper User
You 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.