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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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]
)
)
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
21 | |
13 | |
12 |
User | Count |
---|---|
41 | |
28 | |
25 | |
23 | |
21 |