Forum Discussion
Trouble with KPI Grid by MAQ aggregation
Hello! I'm struggling a bit with the KPI Grid by MAQ. I have some hierarchical data with numerator and denominator columns, and a measure calculating percent. When I put this into the KPI Grid the measure is correct at the row level, however, at parent levels the measure is showing as a sum of all the row measures, rather than calculating the overall percentage for that level. I think this is an issue with the visual rather than the measure, because the same data placed in a matrix is calculating properly. Any ideas?
the data:
the measure:
matrix results:
KPI grid results:
This seems to be a known issue with the visual. You can check the Limitations tab of the sample report.
1 Reply
- v-chuncz-msft
Community Support
This seems to be a known issue with the visual. You can check the Limitations tab of the sample report.