search

sql-bi / Bravo

Bravo for Power BI
MIT License
349 stars 92 forks source link

Create standard aggregate explicit measures #366

Open aghonaim opened 2 years ago

aghonaim commented 2 years ago

The feature request

It would be great if you could consider in the future versions the ability to identify all the numeric columns in the data model and allow us to automatically create key basic explicit aggregate measures like Sum, Avg, Min, Max, Count, etc.

Proposed solution

Show a list of all the all the numeric columns in the data model with a check box each and a list key aggregate measures like Sum, Avg, Min, Max, Count, etc. with a check box each to be able to automatically create all the explicit aggregate measures.

Additional context

This will be another hug time saving feature and I'm sure it will be appreciated by the community.

marcosqlbi commented 2 years ago

It is interesting, but at the same time, it is challenging. Usually, you don't want to sum any numeric column. Providing all the options (list of measures, list of possible aggregations) would result in a more complex UI and the biggest issue is also how to name the resulting measures. Past experience with Power Pivot, where the measure automatically created is named "Sum of ..." makes the model unreadable (you often have to enlarge the pane with names because "Sum of" is the initial of too many measures. We can keep it in the ideas for future releases, but to be honest it's hard to figure out an effective UX that is easy to use, fast, and effective in the results.

aghonaim commented 2 years ago

@marcosqlbi another suggestion for the naming convention for those explicit aggregate measures is: columnnameSum, columnnameAvg, columnnameMax, columnnameMin, etc.