Query against dataset

[DRossi]

Hello.

I have a PowerApp that I'm using to trigger a flow that query's a dataset on PBI Workspace.

I'll be replacing "hamlet" with a string value from a text box in the PowerApp.

The DAX I have so far is the below, but it's not filtering the way I would have thought. In this case it returns nothing:

EVALUATE(FILTER(LocalHeroes_WarrantySearchTable, LocalHeroes_WarrantySearchTable[Address1] IN {"hamlet"}))

The table would look something like this...

ID	CustName	Address1	City
2	John	2 Roche Drive	Ayr
3	Peter	33 Ester Cres	Dublin
4	Alfie	4 Hamlet	Glasgow
5	Mark	18 Bomont	London
6	Emma	74 Cessnock	Manchester

What I want the DAX to do is, search the [Address1] column for any values that contain "hamlet", and then return that row or rows of data.

so:

4

Alfie

4 Hamlet

Glasgow

[DRossi]

@DataInsights awesome, thanks

[DataInsights · Accepted solution]

@DRossi,

Try this:

FILTER(LocalHeroes_WarrantySearchTable, CONTAINSSTRING(LocalHeroes_WarrantySearchTable[Address1], "hamlet"))