Measure not affected by table rows
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.
Group Ranking in Measure, and Bar chart
Hi, I have written dax for group ranking. It is working fine in table. The Ranking is dynamic. If I unselect a value from slicer (carrier name), the ranking gets updated for the selected values. Ranking = RANKX( FILTER( ALLSELECTED('Table'), 'Table'[LaneID] = MAX('Table'[LaneID])), [sum],, ASC, Dense) This is the output of the table It does not work the moment, I remove LaneID. How to make it work even, I do not keep Lane ID in table ?
Finding the difference between the time from first and last occurrence
Hello! I am trying to find the difference in unixtime from when a sensor was first registered to when it was registered again. I color coated the chart to empashize the sensor type. The "Time since last reading" column is the one that I am attempting to create and the one to the right of it has the equations. I am having issue because the pH sensor has 3 readings at different depths, but I only take the difference when the three readings appear again. Opposingly, I only recieve one readign for the ambient temp, water temp, and oxygen level. Any suggestions?
