Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PietroFarias
Resolver II
Resolver II

Return the percentage of a value in a summarized table

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:

exemploDAX.png

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:

exemploDAX2.png

 

And now?

1 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%"
    )
)

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @PietroFarias ,

 

New a calculated column as below:

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


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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%"
    )
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.