Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
yippiekyoo
Frequent Visitor

Filter measure "starts with"

Hi All,

 

working currently on a project where I need to filter certain values from a database in order to categorize them. 

 

I need to have a measure that says filter all part numbers starting with the letter A. 

 

Thats my current function:

Filter function =
SUMX(
FILTER(
'AO Domestic',
'AO Domestic'[Part Number] = "STARTS WITH A"
)
,
'AO Domestic'[Total Actual Cost incl. Retro. Pay])

 

Would be great if someone could tell me how to correct the measure. Thanks a lot in advance.

 

Kind regards

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey,

 

you can write your measure like so

Measure 3 = 
CALCULATE(
	SUM('FactWithDates'[Amount])
	,FILTER(
		'FactWithDates'
		,LEFT('FactWithDates'[Item],1) ="A"
	)
) 

Hopefully this gets you started

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey,

 

you can write your measure like so

Measure 3 = 
CALCULATE(
	SUM('FactWithDates'[Amount])
	,FILTER(
		'FactWithDates'
		,LEFT('FactWithDates'[Item],1) ="A"
	)
) 

Hopefully this gets you started

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi thank you very much  - that works. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.