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 agoNext, you can create a matrix visual in Power BI that uses the Report Name as the row label, the Section Name as the column label, and the measure that you created as the value. This will give you a matrix that displays the number of report views for each Section ID in the report.