Measure doesn't return total

Question

Hi Everyone!I have this measure, in which it looks for every previous value, e if it's equal to the actual value, it returns 1, otherwise 0. Nevertheless, it returns values by date, but doesn't return total in any visual. What could it be?Count.Congelamento = VAR EarlierEntryOfNomeDeOrigem =&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; MAX(fminuto[Timestamp]),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL(fminuto),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fminuto[Nome da Origem]=SELECTEDVALUE(fminuto[Nome da Origem]) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; fminuto[Timestamp]&lt;MAX(fminuto[Timestamp])&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )VAR EarlierEntryOfVazao = CALCULATE(&nbsp; &nbsp; SELECTEDVALUE(fminuto[Vazão],"no value"),&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALL(fminuto),&nbsp; &nbsp; &nbsp; &nbsp; fminuto[Nome da Origem]=SELECTEDVALUE(fminuto[Nome da Origem]) &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; fminuto[Timestamp] = EarlierEntryOfNomeDeOrigem&nbsp; &nbsp; ))VAR Congela = IF(EarlierEntryOfVazao=SELECTEDVALUE(fminuto[Vazão],"no value"), 1, 0)VAR Tabela = ADDCOLUMNS(SUMMARIZE(fminuto, fminuto[Nome da Origem], fminuto[Timestamp]), "Freeze", Congela)RETURNCOUNTROWS(FILTER(Tabela, Congela=1))&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,Please check the first two variables (EarlierEntryOfNomeDeOrigem, EarlierEntryOfVazao), which I suspect return blank values when you use this measure alone.
SELECTEDVALUE function
&nbsp;
If they both return null values, try adding the complete filtering context to the measure in the visual. Please try like:
Measure = SUMX(VALUES('Table'[Data]),[Count.Congelamento])
&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;How to provide sample data

Forum Discussion

Measure doesn't return total

2 Replies

Related content

Measure returning incorrect value

Measure is returning BLANK

DAX Measure Returning Incorrect Results

Create Measure to Return Highest Value

DAX Measure Returns (BLANK)