topic Re: Custom Visual - How to get measure aggregation type in Developer

Custom Visual - How to get measure aggregation type

israelovg — Wed, 30 May 2018 14:54:00 GMT

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
                        }
                    }
                }
            }
        }
    }

Re: Custom Visual - How to get measure aggregation type

v-viig — Thu, 31 May 2018 07:49:33 GMT

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

pbicvsupport@microsoft.com

Re: Custom Visual - How to get measure aggregation type

israelovg — Mon, 04 Jun 2018 14:20:38 GMT

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 .

Re: Custom Visual - How to get measure aggregation type

v-viig — Wed, 06 Jun 2018 07:39:55 GMT

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

pbicvsupport@microsoft.com

Re: Custom Visual - How to get measure aggregation type

v-dancos — Mon, 03 Dec 2018 11:01:03 GMT

Is there any update on how to get measure aggregation type?

Re: Custom Visual - How to get measure aggregation type

v-viig — Tue, 04 Dec 2018 07:13:36 GMT

You can try using the solution described in my previous comments.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com