Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I retrieved a table by DAX STUDIO using the following DAX:
FILTER ( ADDCOLUMNS ( SUMMARIZE ( Despesas, filial[razaoSocial], filial[Loja] ), "SalarioPago", CALCULATE ( [despesasPeriodo], calendario[Periodo] = "2019/03", Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ) ), [SalarioPago] < 0 )
The result was the table below:
I want to create a column called 'percTotal', in which it would be the percent participation of each store over the total value of its company. As in the example below:
And now?
Solved! Go to Solution.
I'm writing a query. So I need to return the additional column in the measure.I got it on another forum. It was as follows:
EVALUATE ADDCOLUMNS ( FILTER ( ADDCOLUMNS ( SUMMARIZE ( Despesas, filial[razaoSocial], filial[Loja] ), "SalarioPago", CALCULATE ( [despesasPeriodo], calendario[Periodo] = "2019/03", Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ) ), [SalarioPago] < 0 ), "percTotal", FORMAT ( DIVIDE ( CALCULATE ( [despesasPeriodo], calendario[Periodo] = "2019/03", Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ), CALCULATE ( [despesasPeriodo], FILTER ( ALL ( calendario ), calendario[Periodo] = "2019/03" ), ALLEXCEPT ( Despesas, filial[razaoSocial] ), Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ), BLANK () ), "0.00%" ) )
Hi @PietroFarias ,
New a calculated column as below:
percTotal = Table[SalarioPago] / CALCULATE ( SUM ( Table[SalarioPago] ), ALLEXCEPT ( Table, Table[razaoSocial] ) )
Best regards,
Yuliana Gu
I'm writing a query. So I need to return the additional column in the measure.I got it on another forum. It was as follows:
EVALUATE ADDCOLUMNS ( FILTER ( ADDCOLUMNS ( SUMMARIZE ( Despesas, filial[razaoSocial], filial[Loja] ), "SalarioPago", CALCULATE ( [despesasPeriodo], calendario[Periodo] = "2019/03", Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ) ), [SalarioPago] < 0 ), "percTotal", FORMAT ( DIVIDE ( CALCULATE ( [despesasPeriodo], calendario[Periodo] = "2019/03", Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ), CALCULATE ( [despesasPeriodo], FILTER ( ALL ( calendario ), calendario[Periodo] = "2019/03" ), ALLEXCEPT ( Despesas, filial[razaoSocial] ), Despesas[Despesa] = "FÉRIAS" || Despesas[Despesa] = "SALÁRIOS ZL" || Despesas[Despesa] = "SALÁRIOS JB" ), BLANK () ), "0.00%" ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |