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
Jay__
Regular Visitor

Using a Measure inside calculate to filter values

I am unable to use a measure inside calculate function please help!

 

Jay___0-1677062171243.png

highlighted one is a measure.

1 REPLY 1
VishalJhaveri
Resolver III
Resolver III

Hello @Jay__ 

Can you try applying the following DAX:

CALCULATE(
	Average(pdt[rfbp]),
	pdt[deliverymethod] = "SHP",
	pdt[rfbp]>0,
	Filter(pdt, 
		pdt[rfbp]< (write measure whole condition over here)
	)
)


Please update me if it works or not.

Thank you. 
If my answer helps, please mark it as solution.

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.

Top Solution Authors
Top Kudoed Authors