Forum Discussion
DiePic
2 years agoResolver II
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]))...
DiePic
2 years agoResolver II
thanks for reply.
I thought that countrows (VAR ContaRows = COUNTROWS(TabellaFiltrata)) will return the value ...
can you give me an example of what you suggest (... Try putting a slicer next to ....)?
thanks in advance
ChiragGarg2512
2 years agoSolution Sage
That just means to use a slicer with TktTempoAccettazione field. After a selection is made, the measure will have a field to work on.
- DiePic2 years agoResolver II
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.Thanks for any idea or suggestion
ChiragGarg2512