Forum Discussion

israelovg's avatar
israelovg
New Member
8 years ago

Custom Visual - How to get measure aggregation type

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 )...
v-viig's avatar
v-viig
Community Champion
8 years ago

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

[email protected]

  • israelovg's avatar
    israelovg
    New Member
    8 years ago

     

    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 .

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      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

      [email protected]