Skip to main content
Implemented

Be able to set Summarize By property for fields for SSAS Tabular endpoints

  • November 6, 2018
  • 1 reply
  • 0 views
R
Forum|alt.badge.img

When creating a SSAS Tabular endpoint from a Semantic Model and consuming it in PowerBI you will find that all numeric fields are given Sum() as default Summarization. While this makes sense in many cases, it doesn't in others.

I.e. you may have a code that is stored as a number, but should not be summed. In SSAS Tabular databases you can set the 'Summarize By' property on a field. It would be very useful to be able to set this property from Discovery Hub.

I do not like the generally proposed solution of converting non-metric numerical fields to character types to avoid summarization, as it feels wrong to change a DWH layer for such a reason.

See the following link for some further context: https://www.sqlchick.com/entries/2017/11/22/why-the-default-summarization-property-in-power-bi-is-so-important 

    This topic has been closed for replies.

    1 reply

    K

    I totally agree.

    It should be possible to set the "summarize by" property in timeXtender.

    It is the main thing that is still lacking from the Tabular Model.
    For me, at the moment, this is the one thing that stops me from saying goodbye to Visual Studio and instead generate the tabular model in timeXtender.

    Change datatype to text is indeed no good workaround.

    Keeping the type as integer is better, for example because it allows you to filter with "between", "greater than", ...
    Handy with a year field, or another numeric field where the order has a meaning.

    Terms & ConditionsCookie settingsAccessibility statement