Forum Discussion

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

DiePic , This measure is working for a selected value of TktTempoAccettazione, so if no value is selected for TktTempoAccettazione then the measure has nothing to work on and hence returns empty. Try putting a slicer next to it with TktTempoAccettazione as the field for it, this should put some value in the card visual.

 

Thank you.

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
2 years ago

Hi ChiragGarg2512 

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's avatar
    ChiragGarg2512
    Icon for Solution Sage rankSolution Sage
    2 years ago

    That just means to use a slicer with TktTempoAccettazione field. After a selection is made, the measure will have a field to work on.

    • DiePic's avatar
      DiePic
      Icon for Resolver II rankResolver II
      2 years ago

      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