Utilización de una tabla virtual, como medida escalar

[Mónica]

Buen día solicito su ayuda ya que tengo la siguiente tabla virtual, debo convertirla en medida, y que cuando lo grafique el valor del cuartil por cada fila en una matriz quede conforme al resultado individual, o cómo se puede graficar la tabla virtual?

prueba = var tabla =

    ADDCOLUMNS(

        ADDCOLUMNS(

            ADDCOLUMNS(

                FILTER(

                    SUMMARIZE('01 Matriz', '01 Matriz'[Login], "NPS", [% NPS]),

                    [NPS] <> BLANK()

                ),

                "Rank", RANKX('01 Matriz', [NPS], , DESC),

                "llave", [NPS] + 1 & '01 Matriz'[Login]

            ),

            "SubRank", RANKX(

                FILTER(

                    SUMMARIZE('01 Matriz', '01 Matriz'[Login], "NPS", [% NPS], "llave", 1 + [% NPS] & '01 Matriz'[Login]),

                    [NPS] <> BLANK()

                ),

                [llave],

                ,

                DESC

            )

        ),

        "PercentileRank",

        VAR _total =

            COUNTROWS(

                FILTER(

                    SUMMARIZE('01 Matriz', '01 Matriz'[Login], "NPS", [% NPS]),

                    [NPS] <> BLANK()

                )

            )

        RETURN

            DIVIDE(

                _total + 1 - (

                    RANKX(

                        FILTER(

                            SUMMARIZE('01 Matriz', '01 Matriz'[Login], "NPS", [% NPS], "llave", 1 + [% NPS] & '01 Matriz'[Login]),

                            [NPS] <> BLANK()

                        ),

                        [llave],

                        ,

                        DESC

                    )

                ),

                _total + 1

            )

    )

     "Cuartil",

    SWITCH(

        TRUE(),

        [PercentileRank] <= 0.25, 1,

        [PercentileRank] <= 0.50, 2,

        [PercentileRank] <= 0.75, 3,

        [PercentileRank] > 0.75, 4

    )

var Q =

AVERAGEX(tabla,[Cuartil])

return

Q

Muchas gracias

[Anonymous]

Hi @Mónica ,

Thank you for using Fabric Community.

Apologies for the delay in reply from our side. Did you got a resolution for this?
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help.

[Anonymous]

Hello @Mónica ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .

[Anonymous]

Hi @Mónica ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. If you have any question relating to the current thread, please do let us know and we will try out best to help you. In case if you have any other question on a different issue, we request you to open a new thread .