Forum Discussion

leolapa_br's avatar
leolapa_br
Icon for Resolver II rankResolver II
2 years ago
Solved

Summary table from VAR temporary table

I have produced the following VAR (temporary) table called 'Tabela_CP_DiasxValor_DiasPeso_Dias' with 300+ rows: What I need is to come up with another VAR table that basically summarizes the v...
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    GROUPBY is cleaner but another option would be to filter Tabela inside the SUMX.

    VAR Tabela_CP_DiasporForn =
    ADDCOLUMNS (
        SUMMARIZE ( Tabela_CP_DiasxValor_DiasPeso_Dias, [Código - Nome do fornecedor] ),
        "@DiasSoma",
            VAR _Codigo = [Código - Nome do fornecedor]
            RETURN
                SUMX (
                    FILTER (
                        Tabela_CP_DiasxValor_DiasPeso_Dias,
                        [Código - Nome do fornecedor] = _Codigo
                    ),
                    [@Dias]
                )
    )