Issues with Funnel Visual

[fbarini]

Hello, folks, I'm trying to include a Funnel Visual, but I'd like to also include the TOTALS on the first row, but in a way that it auto sort the remaining rows in a descending way. I managed to get it by using below, but I'm not being able to add the first row as the second example (this would be done in way that I could display the % of total alongwith the Number, which is very important here).

Below the Measure used above:

Sol. Efetuadas = COUNTA(BaseAppVagas[Id])
StatusAprovFluxo is a Choice Column containing the following possibilities ["Approved"; "Hired"; "Rejected"; "In Analysis"]

Here, the problem lies with the auto sorting. Altough I cant get it to work with totals, I can't make the remainings rows auto sort themselves. Any suggestions?

Below the Measures used above:

Sol. Efetuadas = COUNTA(BaseAppVagas[Id])
Sol. Em Analise = CALCULATE([Sol. Efetuadas], BaseAppVagas[StatusAprovFluxo] = "Em Análise")
Sol Reprov = CALCULATE([Sol. Efetuadas], BaseAppVagas[StatusAprovFluxo] = "Reprovado")
Sol. Aprovados = CALCULATE([Sol. Efetuadas], BaseAppVagas[StatusAprovFluxo] = "Aprovado")
Sol. Contratados = CALCULATE([Sol. Efetuadas], BaseAppVagas[StatusAprovFluxo] = "Contratado")

[MFelix]

Hi @fbarini ,

Create a table with the status you need:

Now add the following measure:

Total = SWITCH(
            SELECTEDVALUE(Tipo[ID]),
                1,  [Sol. Efetuadas],
                2,  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Em Análise"),
                3,  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Reprovado"),
                4,  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Aprovado"),
                5,  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Contratado")
            )

Do your funnel with the column Tipo on the group and the measure on the values:

[fbarini · Accepted solution]

Not actually working... I'm getting an error "Switch Function cannot compare Text and Integers. Consider using Value or Format). And I did all the above..

But you gave me an idea. I added a new calculated column to your table "Tipo" with the totals and gone for:

Totals = TESTE = SUM(Teste[Totais])
Funnel:
Group - Tipo
Values - Totals

And finally got it! Thank you very much!

[MFelix]

Hi @fbarini ,

That error occured because the format of the column ID was not formatted has number, ussualy I use an ID to make the switch to simplify the coding but you can use simple text so would be similar to this:

Total = SWITCH(
            SELECTEDVALUE(Tipo[Tipo]),
                "Sol. Efetuadas",  [Sol. Efetuadas],
                "Sol. Em análise",  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Em Análise"),
                "Sol. Reprov",  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Reprovado"),
                "Sol Aprovados",  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Aprovado"),
                "Sol. Contratados",  CALCULATE([Sol. Efetuadas],  BaseAppVaga[StatusAprovFluxo] = "Contratado")
            )