Show data filtered in a table

[Juliano845]

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 

name	hour	call	time
Joseph	9:30	delivered	5
Anthony	11:00	delivered	35
Mary	14:00	abandoned	32

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

like this:

name	hour	call	time
Anthony	11:00	delivered	35

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.

[v-zhangti]

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.

[johnt75 · Accepted solution]

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