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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Cube measure filter

hello,

 

I have the following Measure in advance editor for which I would like to filter out values that are <=0. Any idea how to do this? The connection is a SAP BW which doesn't offer this paramater to be filtered out before loading the data.

 

{Cube.AddMeasureColumn, "Open Order Value#(cr)#(lf)(Loc curr)", "[Measures].[4A11M1VG69CO7RA1WCUL84JLF]"},

 

P.S. filtering out the values after loading the data doesn't work since there are hundreds of thousand of results <=0 and this crashed my laptop or just takes to long to load.

Thank you!

2 REPLIES 2
fzfz
Frequent Visitor

Hello ,

If anyone has a good idea on how to do this better, I would be more than happy 

Thank you 
Anonymous
Not applicable

bump

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.