Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hey guys,
I'm writing a custom matrix visual . The dataview has a matrix , when I get measures data(Values) , I need to know what type of aggregation measure is (sum, count , average , min ,max ).
How can I get measure aggregation type programmatically?
Here is my capabilities.json
{ "dataRoles": [ { "displayName": "Rows", "name": "rows", "kind": "Grouping" }, { "displayName": "Columns", "name": "columns", "kind": "Grouping" }, { "displayName": "Filters", "name": "filters", "kind": "Grouping" }, { "displayName": "Values", "name": "measure", "kind": "Measure" } ], "dataViewMappings": [ { "conditions": [ { "rows": { "max": 0 }, "columns": { "max": 0 }, "measure": { "min": 1 } }, { "rows": { "min": 1 }, "columns": { "min": 0 }, "measure": { "min": 0 } }, { "rows": { "min": 0 }, "columns": { "min": 1 }, "measure": { "min": 0 } } ], "matrix": { "rows": { "select": [ { "for": { "in": "rows" } }, { "for": { "in": "filters" } } ], "dataReductionAlgorithm": { "top": { "count": 30000 } } }, "columns": { "for": { "in": "columns" }, "dataReductionAlgorithm": { "top": { "count": 10000 } } }, "values": { "select": [ { "bind": { "to": "measure" } } ] } } } ], "objects": { "total": { "displayName": "Show Total", "properties": { "columnTotal": { "displayName": "Column", "type": { "bool": true } }, "rowTotal": { "displayName": "Row", "type": { "bool": true } }, "columnGrandTotal": { "displayName": "Grand Column", "type": { "bool": true } }, "rowGrandTotal": { "displayName": "Grand Row", "type": { "bool": true } } } } } }
Is there any update on how to get measure aggregation type?
You can try using the solution described in my previous comments.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
There's not good way to detect type but you might try to detect type by displayName.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I 'm trying to calculate matrix measure totals/subtotals (sum,count,average,min,max) .
Is there a way configure my capabilities.json that will bring matrix measure subtotals for row/column items?
Thanks in Advance .
No, subtotals are not supported yet. This feature is on our backlog (no ETA).
Just one more note, If you calculate totals in JS they might be a bit wrong as Power BI does not allow to get more than 1000 rows by default. This value can be configure via dataReductionAlgorithm but it can't be greater than 30000.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |