Return the percentage of a value in a summarized table

[PietroFarias]

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?

[v-yulgu-msft]

Hi @PietroFarias ,

New a calculated column as below:

percTotal =
Table[SalarioPago]
    / CALCULATE (
        SUM ( Table[SalarioPago] ),
        ALLEXCEPT ( Table, Table[razaoSocial] )
    )

Best regards,

Yuliana Gu

[PietroFarias · Accepted 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%"
    )
)