Forum Discussion
Solved
filter table with right output
Hi everyone, I have a measurement that gives the right output.... this is the measurement code: - Tempo_Risposta_Count = VAR ReplyTime = VALUE(SELECTEDVALUE(Ticket_Data[TktTempoAccettazione]))...
That just means to use a slicer with TktTempoAccettazione field. After a selection is made, the measure will have a field to work on.
Now with this measure (last column)
Tempo_Risposta_Concordato_Count =
//
VAR ReplyTime = VALUE(SELECTEDVALUE(Ticket_Data[TktTempoAccettazione]))
//
VAR Filtra =
IF(ReplyTime < 61
, 0
,IF([Tempo_Risposta_Concordato] = 0
,0
,IF(([Tempo_Risposta_Concordato] - ReplyTime) >= 0
,0
,1
)
)
)
VAR Result = VALUE(Filtra)
RETURN Result
I can distinguish with numbers the rows with values .... but as you can see in the card (on the right "1ma Risposta"), I'm not able to have a sum.
I can distinguish with numbers the rows with values .... but as you can see in the card (on the right "1ma Risposta"), I'm not able to have a sum.
Thanks for any idea or suggestion
ChiragGarg2512