Measure not affected by table rows

[Aurore]

Hello, everyone!

I'm doing a measure that need to show me a value based on the total of a count. Depending on the total, it's going to show me diferent values, like: 

1 to 24 = 47,00
25 to 30 = 55,00
31 to 40 = 60,00
More than 41 = 65,00

 

When I use this measure on a card it works perfectly, it shows me the exactly value I need, like the image below:

But, when I try to use this on a TABLE it breaks the value per row. On the total it show correctly how the value is supposed to be, but on the rows it shows the minimum value. There's a way to make the measure show me the value in the total cell on the rows?

 

The measure I using is this one:

VALOR_COMISSAO = 
    VAR qtd_benef = 
        CALCULATE(
            DISTINCTCOUNT('power_bi gestao_contratos'[codigo_pessoa]),
            FILTER('power_bi gestao_contratos','power_bi gestao_contratos'[indica_plano_ant] = "N"),
                    'power_bi gestao_contratos','power_bi gestao_contratos'[SITUAÇÃO FATURA] = "PAGO",
            KEEPFILTERS('Tb_Calendário'[Competencia]),
            REMOVEFILTERS('Tb_Calendário'[Ano]))
    VAR valor_comissao = 
        CALCULATE(   
            MAXA('power_bi comercial_val_comiss_consult'[valor]),
            FILTER('power_bi comercial_val_comiss_consult',
                    'power_bi comercial_val_comiss_consult'[vidas_inicial] <= qtd_benef),
            GROUPBY('power_bi gestao_contratos','power_bi gestao_contratos'[nome_vendedor]),
            KEEPFILTERS('Tb_Calendário'[Competencia]),
            REMOVEFILTERS('Tb_Calendário'[Ano]))
    RETURN valor_comissao

 Basically this measure has two steps separated in two variables:

• qtd_benef: this measure count the values that will be used in the next step. 
• valor_comissao: the result of "qtd_benef" is the value used on the FILTER command to get the value of MAXA. 

the QTD_BENEF it the (34) and VALOR_COMISSAO is (60) that appears on the first image. 

Thanks in advance,

Daniel.

[lbendlin]

Read about HASONEVALUE and use that in your measure.