Measure not affected by table rows

Aurore — Tue, 23 Apr 2024 13:06:56 GMT

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.

Re: Measure not affected by table rows

lbendlin — Wed, 24 Apr 2024 00:12:39 GMT

Read about HASONEVALUE and use that in your measure.

topic Re: Measure not affected by table rows in DAX Commands and Tips

Measure not affected by table rows

Re: Measure not affected by table rows