Forum Discussion

DiePic's avatar
DiePic
Resolver II
2 years ago
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]))
VAR TabellaFiltrata =
    FILTER(
        Ticket_Data,
         ReplyTime > 60
    )
VAR ContaRows = COUNTROWS(TabellaFiltrata)
VAR Result = ContaRows
RETURN Result
-

....

and the result is correct if I insert this formula into my matrix table as you can see in the image below.

 

but I can't get the total in a card

 

Where am I doing wrong?
Thanks in advance for any suggestions

 

Need Help

6 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution 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
      Resolver 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
        Solution 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.