Forum Discussion

Juliano845's avatar
Juliano845
Frequent Visitor
4 years ago
Solved

Show data filtered in a table

Hello everyone,

 

Please, I need help with this problem:

 

I'm trying to filter data from this table and show this information in a visual table 

 

namehourcall time
Joseph9:30delivered5
Anthony11:00delivered35
Mary14:00abandoned32

 

so I need the information from the line where the call has been delivered and the time over than the 30

 

like this:

namehourcalltime
    
Anthony11:00delivered35
    

 

I created a visual table and tried to filter using :

 

Medida = FILTER('Table ', 'Table'[Call]= "Delivered" && 'Table'[time]<30 )
 
could somebody help me please? Thank you.
  • johnt75's avatar
    johnt75
    4 years ago

    You could create a measure like

    Row is visible = IF( SELECTEDVALUE('Table'[call]) = "delivered" && SELECTEDVALUE('Table'[time]) >= 30, 1)

    then add that as a filter to your visual to show only rows where it is 1

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    You could create a measure like

    Row is visible = IF( SELECTEDVALUE('Table'[call]) = "delivered" && SELECTEDVALUE('Table'[time]) >= 30, 1)

    then add that as a filter to your visual to show only rows where it is 1

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Juliano845 

     

    In response to the addition of johnt75 's answer, put Measure into Filter and set it equal to 1 to get the result you want.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.