Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 vendors column highlighted to the left and group them so I get on a second column the total of "@Dias" highlighted to the right for each vendor.
I tried doing that with the following code:
VAR Tabela_CP_DiasporForn =
SUMMARIZE(
Tabela_CP_DiasxValor_DiasPeso_Dias,
[Código - Nome do fornecedor],
"@DiasSoma", SUMX(Tabela_CP_DiasxValor_DiasPeso_Dias, [@Dias])
)
But what I end up getting is the summarized table (100+ rows, which is correct) but with the overall total of "@Dias" instead of the total by row/vendor:
I tried going with SUM instead of SUMX but DAX won't take the [@Days] column since it comes from the previous VAR table, and CALCULATE produces the same outcome.
How can I get that done? Any help is appreciated!
Solved! Go to Solution.
@leolapa_br Use GROUPBY with SUMX( CURRENTGROUP(), [@Days] )
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]
)
)
@leolapa_br Use GROUPBY with SUMX( CURRENTGROUP(), [@Days] )
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]
)
)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
28 | |
23 | |
22 | |
22 |